compare two tables in the same database
I don't see why the tables have to reside in different databases, backup, source control, or scripts folder in order to run SQL Data Compare.
It wouldn't be much fuzz to add the ability to compare two tables regardless (i.e. in the same database). Sometimes I just need to divide the common traits from the differences, in order to plan some work.
-
@Hans - I think this *is* possible today. In the Edit Project screen can you visit the Tables and Views tabs, and using the buttons at the bottom of the screen, unmap the two tables that you want to compare, and remap the two that you want to compare.