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

PK dropped for no purpose with version 5.2

When trying to synch two databases that differed only by their extended properties, the script generated by SQL Compare dropped a number of FK and PK, recreated some, but not all of them.

Result: errors at execution time.

Running just the part of the script adding the extended properties was ok and a schema compare done afterwards showed identical schemas. There is indeed a problem with 5.2

runned on sql 2005 version 9.00.2047.00

any help appreciated.

Eric
Eric
0

Comments

5 comments

Sort by
  • Brian Donahue
    Eric,

    Are you comparing SQL 2000 to 2005?
    Brian Donahue
    0
  • Eric
    No 2005 only. Same server in fact.
    Eric
    0
  • Brian Donahue
    Hi Eric,

    Sorry but I'm flying blind here. I don't have any known problems logged that would cause this. I'm going to have to ask you for some schema snapshots for these two databases. If you don't mind, you can send them to support at red-gate.com.

    Thanks!
    Brian Donahue
    0
  • Eric
    Brian,

    I think I have found the culprit. In reviewing the compare options I was surprise to see that Ignore Indexes was ON. The "Ignore" word is in the header and easy to miss and my eye just saw that Indexes was checked.

    Anyway, that schema has some FK defined on unique indexes that are not necessarily PK. This is legal/valid and there are good design reasons for this (NULL are invalid in PK but not in unique keys & I dislike compound PK made of 4+ columns).

    I unchecked that option and the synch script was ok...

    Eric
    Eric
    0
  • Brian Donahue
    I'll keep that in mind for the future. Thanks!
    Brian Donahue
    0

Add comment

Please sign in to leave a comment.