Compare two views in the same database

Forum for users of SQL Compare schema synchronization utility

Compare two views in the same database

Postby rpe » Fri Feb 14, 2014 5:58 pm

I would like to compare to views in the same database but have not been able to figure out how to do it. We have the original view and the new version of the view with different names.
Posts: 1
Joined: Fri Feb 14, 2014 5:56 pm

Postby eddie davis » Mon Feb 17, 2014 4:05 pm

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.

Many Thanks
Eddie Davis
Technical Support Engineer
Red Gate Software Ltd
eddie davis
Posts: 1148
Joined: Wed Jun 14, 2006 2:47 pm
Location: Red Gate Software

Return to SQL Compare Previous Versions

Who is online

Users browsing this forum: No registered users and 0 guests