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

Duplicate Drop\Create Foreign Key Statements

I compared a database with 750 tables. The generated script used to update the data created duplicate drops and create statements for the same foreign key. After deleting about a dozen of these statements, I gave up and promoted only a few tables at a time.

Is this a problem because I am using such a complex database?
dbirdil
0

Comments

1 comment

Sort by
  • Brian Donahue
    It sounds like a bit of a design issue. Data Compare has an option to disable foreign keys, triggers, and primary keys, and it should do this even if the FK is defined on the table at the other end of the relationship, if this option is set. I'd assume the program is doing this twice because both tables in the relationship are being synchronized.

    Does this cause the script to throw an error when it is run on the SQL server?
    Brian Donahue
    0

Add comment

Please sign in to leave a comment.