Working on a legacy project that has a SQL Server database with 50+ tables and 100+ stored procedures. Once every quarter, we manually replace the development and test databases with a database from production. The only problem is that the developers and testers do not have an account on production, hence their accounts need to be manually recreated once the dev / test database has been replaced.

Working on a legacy project that has a SQL database with 50+ tables and 100+ stored procedures, once every quarter we manually replace the development and test databases with a database from production. The only problem is that the developers and testers do not have an account on production, hence their accounts need to be manually recreated once the dev / test database has been replaced.