When you choose to compare two databases, tables in those databases are mapped with each other by name, i.e. an Employee table on the source database is mapped to the same Employee table on the target database. Mapping rules could alter the name-mapping, but not my much.

If you wish to compare a few specific tables (or views), that do not share the same name, click Compare Tables/Views on the SQL Data Compare ribbon.

In addition to tables, data compare has the ability to compare views as well, if the comparison option Compare and Synchronize Views is checked. Synchronizing views however may not always succeed.

The following considerations apply to views:

Once you make your selections, click Read Database Objects. This populates two list boxes with the database tables and optionally the database views.

To map two objects, select the first object on the left list box, then select the second object on the right list box and click the "left-to-right" arrow button. The mapping appears in the Mapped Objects list box. To remove a mapping, selected the mapped objects and click on the "right-to-left" arrow button.


 |    |  |   |   |   


Save

Save

Save

Save