Joined: 14 Jun 2006
Location: Red Gate Software
|Posted: Mon Feb 17, 2014 5:05 pm Post subject:
|Thank you for your forum post.
What you are seeking cannot be achieved with two views in SQL Compare.
It is possible with the table objects to compare two different tables in the same database via the Table Mapping tab (or open an existing project and edit project ->Mapping table Tab) in the project configuration.
In my simple example I have the following 3 tables, table_A, table_B and table_Z. In normal operations table_A will be mapped to table_A, table_B mapped to table_B and so table_Z mapped to table_z. In this example, I wish to compare table_A with table_Z.
Select the same database for both data sources.
Table Mapping Tab -> Unmap table_A to table_A and table_Z to table_Z.
Map table_A to table_Z.
Click the Compare now button.
I hope the above helps.
Technical Support Engineer
Red Gate Software Ltd