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?
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.