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?