Compare tables with different names

Automate and integrate using the SQL comparison API

Moderator: Chris Auckland

Compare tables with different names

Postby alex_sefrin » Tue Jun 01, 2010 4:33 pm

Sorry, I only worked with SQLDataCompare by now and I’m new to SQLCompare. Maybe this very easy to solve…

I need to compare the schema of two databases, which have only a few tables in common. Database A has more than 1000 objects and I would like to compare them with database B which has only a few tables. The tablenames in database B are not the same as in database A but the structure should be equal, except the differences I would like to find.

With SQLDataCompare I could add the tables to Mappings and then compare. With SQLCompare I have to compare the full database with CompareWith?! That will need some time…

I’ve seen that there is a filter method on Differences, but how can I tell the SQLCompare to compare databaseA.tablename123 with database.tablenameyxz?

Thanks
Alex
alex_sefrin
 
Posts: 9
Joined: Thu Jan 08, 2009 11:24 am

Postby Brian Donahue » Wed Jun 02, 2010 5:57 pm

Hi Alex,

SQL Compare, unlike SQL Data Compare, does not support comparing two differently-named tables in the same database. Your only option for comparing different objects is when the schema is different, so for instance, you could compare [bob].[Table_1] to [fred].[Table_1].

If you have any more questions, please let us know.
Brian Donahue
 
Posts: 6670
Joined: Mon Aug 23, 2004 10:48 am

Postby alex_sefrin » Mon Jun 07, 2010 8:31 am

Hi Brian,

I don't want to compare two tables in one db.

I want to compare tables with different names in different dbs.
[database1].[Table_xyz] to [database2].[Table_123]
alex_sefrin
 
Posts: 9
Joined: Thu Jan 08, 2009 11:24 am

Postby Brian Donahue » Mon Jun 07, 2010 9:27 am

Same applies in different databases.
Brian Donahue
 
Posts: 6670
Joined: Mon Aug 23, 2004 10:48 am


Return to SQL Comparison SDK Previous Versions

Who is online

Users browsing this forum: No registered users and 0 guests