Red Gate forums :: View topic - Compare two views in the same database
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Compare 10
SQL Compare 10 forum

Compare two views in the same database

Search in SQL Compare 10 forum
Post new topic   Reply to topic
Jump to:  
Author Message
rpe



Joined: 14 Feb 2014
Posts: 1

PostPosted: Fri Feb 14, 2014 6:58 pm    Post subject: Compare two views in the same database Reply with quote

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.
Back to top
View user's profile Send private message
eddie davis



Joined: 14 Jun 2006
Posts: 890
Location: Red Gate Software

PostPosted: Mon Feb 17, 2014 5:05 pm    Post subject: Reply with quote

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
Technical Support Engineer
Red Gate Software Ltd
E-mail: support@red-gate.com
Back to top
View user's profile Send private message Send e-mail
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group