How can we help you today? How can we help you today?

SQL Compare Suggestion

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
djinni69
0

Comments

2 comments

Sort by
  • JonathanWatts
    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.

    Regards,

    Jonathan
    JonathanWatts
    0
  • jimboh
    :cry: There must be a poormans solution..
    jimboh
    0

Add comment

Please sign in to leave a comment.