What are the challenges you face when working across database platforms? Take the survey
Options

Different schemas - Compare aborts on first duplicate table

dbaman6dbaman6 Posts: 7
edited April 19, 2006 10:48AM in SQL Compare Previous Versions
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?

Comments

  • Options
    Hi

    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
    Daniel Handley
    Red Gate Software Ltd
This discussion has been closed.