Red Gate forums :: View topic - Is it possible to compare different table names
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Data Compare Previous Versions
SQL Data Compare Previous Versions forum

Is it possible to compare different table names

Search in SQL Data Compare Previous Versions forum
Post new topic   Reply to topic
Jump to:  
Author Message
dbdmora



Joined: 21 Nov 2011
Posts: 33
Location: Atlanta, GA

PostPosted: Thu Jan 05, 2012 5:10 pm    Post subject: Is it possible to compare different table names Reply with quote

I have two tables with the same structure but different names on same database. Is it possible to data compare these tables within same database?
Back to top
View user's profile Send private message
eddie davis



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

PostPosted: Thu Jan 05, 2012 6:50 pm    Post subject: Reply with quote

Hi,
Thank you for your post into the forum.

The answer to your question is yes, what you are seeking to achieve can be done.

You select the same database for each data source. Next select the Object Mapping Tab in the Project Configuration.

You will see that each table name is mapped, for example:

    Table_name 1 mapped to Table_name 1
    Table_name 2 mapped to Table_name 2
    Table_name 3 mapped to Table _name 3


So in my example, I wish to map Table_name 1 to Table_name 3.
First I need to unmap Table_name 1 in the left hand data source with the table of the same name in the right data source. Repeat the unmap process for Table_name 3.

Now map Table_name 1 in the left hand data source to Table_name 3 in the right hand data source.

Once you are happy with your project configuration, click the Compare Now button.

All being well and SQL Data Compare can identify a comaprison key, you will see a set of comparison results that informs on the data differences between the mapped tables.

Further information is available in the SQL Data Comapre help information available using this LINK.

I hope the above answers your question.

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
dbdmora



Joined: 21 Nov 2011
Posts: 33
Location: Atlanta, GA

PostPosted: Thu Jan 05, 2012 9:03 pm    Post subject: Reply with quote

Ok, I got it to map table_name 1 to Table_name 2 but it didn't compare anything because it could not identify a comparison key. Even though I did set a Comparison Key on both tables under the Table and Views tab first.

Is this something that will be added in a future release or another way to accomplish this?

Thanks
Back to top
View user's profile Send private message
eddie davis



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

PostPosted: Tue Jan 10, 2012 4:55 pm    Post subject: Reply with quote

Thank you for your reply.

There is nothing to add, providing you can set a comparison key that can uniquely identify each row of data between the two mapped tables.

If required choose more than one column or all the columns to make the comparison key.

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