Compare tables with different names

[alex_sefrin]

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

[Brian Donahue]

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
Technical Support
Red Gate Software Ltd.
44 (0)870 160 0037 ext 8521
US and CAN 1-866-RED GATE ext 8521

[alex_sefrin]

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]

[Brian Donahue]

Same applies in different databases.
_________________
Brian Donahue
Technical Support
Red Gate Software Ltd.
44 (0)870 160 0037 ext 8521
US and CAN 1-866-RED GATE ext 8521