How to compare tables in different schemas
ppd
Posts: 4
Using SQL Compare 6, is it possible to compare tables from one database that are in dbo, to tables in another database that are broken out into various schemas. For example, our original database has all of the tables in dbo. In our new database, we have put the tables in various schemas for organization purposes. Now, we would like to compare tables from dbo in the original database to their counterpart in the new database that is actually in a different schema. Is it possible to create some sort of mapping that tells the tool that a table from database A maps to a specific schema.table in database B? Thanks for your help.
Comments
The 'Map owners' button at the bottom-left of the comparison project window allows you to do this. Mapping 'owners' on a SQL 2005 server is the same as mapping schema.
Enjoy!
I had tried doing that originally, but here is the issue that I had: All of the tables in the first database belong to dbo. In the second database, there are a few tables that belong to dbo, but the other tables are broken into multiple schemas (HR, ACCT, PAYROLL, INV, etc). Since the mapping tool already mapped dbo to dbo, there did not appear to be a way to map dbo to multiples schemas from the second database. I tried unmapping dbo, and then tried to map it to more and one shema (holding down the <CTRL> key, but that didn't work). Any suggestions? Thanks.
David Atkinson
Red Gate Software
Product Manager
Redgate Software