SQL Compare Suggestion

djinni69djinni69 Posts: 13
edited January 29, 2007 10:28AM in SQL Compare Previous Versions
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 :)


  • Hi there,

    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.


    Jonathan Watts

    -Project Manager
    -Red Gate Software Ltd
  • :cry: There must be a poormans solution..
Sign In or Register to comment.