Comparing the data of two tables in the same database
Published 05 June 2013
For testing and data sanitization reasons, you may want to compare data in two similar tables in the same database.
To do this, specify the same server and database as the source and target. Next, click the Object Mapping tab, and map together the tables you want to compare. For information about how to map tables, see Mapping objects.
If the columns of the tables are named differently, it may be necessary to map the individual columns together as well.
Make sure the data types of the columns you map together are the same, or at least similar. For example, it's possible to map together CHAR and NVARCHAR columns, int and tinyint columns, and decimal and float columns.