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 Comparison SDK Previous Versions
SQL Comparison SDK Previous Versions forum

Compare tables with different names

Search in SQL Comparison SDK Previous Versions forum
Post new topic   Reply to topic
Jump to:  
Author Message
alex_sefrin



Joined: 08 Jan 2009
Posts: 9

PostPosted: Tue Jun 01, 2010 4:33 pm    Post subject: Compare tables with different names Reply with quote

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
Back to top
View user's profile Send private message
Brian Donahue



Joined: 23 Aug 2004
Posts: 6580

PostPosted: Wed Jun 02, 2010 5:57 pm    Post subject: Reply with quote

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.
Back to top
View user's profile Send private message
alex_sefrin



Joined: 08 Jan 2009
Posts: 9

PostPosted: Mon Jun 07, 2010 8:31 am    Post subject: Reply with quote

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]
Back to top
View user's profile Send private message
Brian Donahue



Joined: 23 Aug 2004
Posts: 6580

PostPosted: Mon Jun 07, 2010 9:27 am    Post subject: Reply with quote

Same applies in different databases.
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