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.
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
Eddie Davis Senior Product Support Engineer
Redgate Software Ltd
Email: support@red-gate.com
Comments
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
Senior Product Support Engineer
Redgate Software Ltd
Email: support@red-gate.com