Keeping SQL Enviroments in sink | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Keeping SQL Enviroments in sink

I just have one question , How do I keep my test , dev sql Environments in sink. I do not have any 3de party tools to do this and it takes forever to do it manual. I also have date in the test Environment that I would like to keep, so I can not backup and restore to test. Any suggestions?
The best option is to Generate SQL scripts against Production databases and apply the same to the test environment, for any schema changes in Production must be tested in Development before. Satya SKJ
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.