Compare two views in the same database

rperpe Posts: 2
edited February 17, 2014 11:05AM in SQL Compare Previous Versions
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.

Comments

  • Eddie DEddie D Posts: 1,800 Rose Gold 5
    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
    Eddie Davis
    Senior Product Support Engineer
    Redgate Software Ltd
    Email: support@red-gate.com
Sign In or Register to comment.