Backup/restore check data is the same SQL Server

Posted on

Question :

I’m a trainee SQL DBA. I’m using SSMS 2008r2.
I’ve backed up a database and restored this as a new database on a new instance.
I want to check to see if the data is the same on both databases. Is there a way I can do this without running select commands on both databases and comparing?


Answer :

SQL Server Data Tools offers a Data/Schema comparison option. You need to install it, previous download of it, and then do the comparison.

More information on how to compare in How to: Compare and Synchronize the Data of Two Databases.

To download the free tool, please visit

Leave a Reply

Your email address will not be published. Required fields are marked *