Compare tables with different names?

Compares and synchronizes SQL database content.

Moderators: JonathanWatts, Chris Auckland, David Atkinson, Michelle Taylor, chengvoon.tong

Compare tables with different names?

Postby jamieuka » Wed Mar 28, 2012 12:28 pm

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.
jamieuka
 
Posts: 4
Joined: Tue Jan 03, 2012 10:15 am

Postby Brian Donahue » Wed Mar 28, 2012 1:48 pm

Hello,

Yes, no problem at all, just create a mapping between SP and SP2.
http://www.red-gate.com/supportcenter/c ... ataSources
Brian Donahue
 
Posts: 6670
Joined: Mon Aug 23, 2004 10:48 am

Postby jamieuka » Wed Mar 28, 2012 1:55 pm

Thanks, I see now, very easy :)
jamieuka
 
Posts: 4
Joined: Tue Jan 03, 2012 10:15 am


Return to SQL Data Compare 10

Who is online

Users browsing this forum: No registered users and 0 guests