Duplicate Drop\Create Foreign Key Statements

dbirdildbirdil Posts: 8
edited September 14, 2006 12:41AM in SQL Data Compare Previous Versions
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?

Comments

  • Brian DonahueBrian Donahue Posts: 6,590 New member
    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?
This discussion has been closed.