Red Gate forums :: View topic - Compare tables with different names?
Return to www.red-gate.com RSS Feed Available

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

Compare tables with different names?

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



Joined: 03 Jan 2012
Posts: 4
PostPosted: Wed Mar 28, 2012 12:28 pm    Post subject: Compare tables with different names? Reply with quote
For example, I want to compare a base table named `SP` with a second base table named `SP2` (in the same database but can be copied to another database if required).

I found a support article entitled Selecting Tables With Unrelated Names but it seems to still compare tables using exact names, merely applies a 'fuzzy filter' to determine which tables to include.
Back to top
View user's profile Send private message
Brian Donahue



Joined: 23 Aug 2004
Posts: 6369
Location: Red Gate Software
PostPosted: Wed Mar 28, 2012 1:48 pm    Post subject: Reply with quote
Hello,

Yes, no problem at all, just create a mapping between SP and SP2.
http://www.red-gate.com/supportcenter/content/SQL_Data_Compare/help/10.0/SDC_MappingDataSources
_________________
Brian Donahue
Technical Support
Red Gate Software Ltd.
44 (0)870 160 0037 ext 8521
US and CAN 1-866-RED GATE ext 8521
Back to top
View user's profile Send private message
jamieuka



Joined: 03 Jan 2012
Posts: 4
PostPosted: Wed Mar 28, 2012 1:55 pm    Post subject: Reply with quote
Thanks, I see now, very easy Smile
Back to top
View user's profile Send private message
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