How can we help you today? How can we help you today?

Different schemas - Compare aborts on first duplicate table

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?
dbaman6
0

Comments

1 comment

Sort by
  • Daniel Handley
    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
    0

Add comment

Please sign in to leave a comment.