Backup/restore check data is the same SQL Server

backuprestore

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?

Thanks.
Ryan.

Best 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 https://msdn.microsoft.com/en-us/library/hh272686(v=vs.103).aspx.