Different schemas - Compare aborts on first duplicate table
dbaman6
Posts: 7
I have a database with 16,000 tables with 15,000 owned by dbo and 1,000 owned by an individual. 2 things:
1) Tablenames are identical between the two, only the owner differs.
2) SQL compare aborts the comparison on the first dupilicate tablename (but they do have different owners / schemas)
I need to compare the 1000 tables with another database that has a few less tables but the tables are not owned by dbo. Any ideas on how to recognize the schema or just to compare the 1000 tables to the other 1000 tables?
1) Tablenames are identical between the two, only the owner differs.
2) SQL compare aborts the comparison on the first dupilicate tablename (but they do have different owners / schemas)
I need to compare the 1000 tables with another database that has a few less tables but the tables are not owned by dbo. Any ideas on how to recognize the schema or just to compare the 1000 tables to the other 1000 tables?
This discussion has been closed.
Comments
The problem is that the owner of the object is included in the name. Therefore two objects names dbo.table1 and user.table1 are different and by default won't be mapped.
In version 5 you can now map an owner against another to get around this, but you can only do one owner at a time.
The solution is to change the owners using the change owbner or rename sp depending on your situation.
Regards
Dan
Red Gate Software Ltd