SQL Compare Suggestion
djinni69
Posts: 13
I love the Red Gate products, and I'd like to offer a suggestion for a future release of SQL Compare:
Add an option to snapshot an entire SQL Server instance (all user databases minimum), with the ability to schedule compares against the "instance snapshot".
This would be an enormous help to me, as I currently have to script each individual database compare in order to perform a total instance compare. We use this to verify each morning that the SQL instance is 100% identical to our baselines, and in turn, it ensures that our baselines are up to date.
Just a suggestion
Brett
Add an option to snapshot an entire SQL Server instance (all user databases minimum), with the ability to schedule compares against the "instance snapshot".
This would be an enormous help to me, as I currently have to script each individual database compare in order to perform a total instance compare. We use this to verify each morning that the SQL instance is 100% identical to our baselines, and in turn, it ensures that our baselines are up to date.
Just a suggestion
Brett
Comments
Thanks for your suggestion, we may consider this for future versions. However, if you wanted to do this right now it should be possible to do this by either:
a) Using a command line batch file and a scheduled task.
b) Using the SQL Toolkit's to write a .NET application to compare the entire instance.
Regards,
Jonathan
-Project Manager
-Red Gate Software Ltd