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

"DropConstraintsAndIndexes" doesnt drop constraint.

There is strange behavior in latest SQLDataCompare v12.3.3.4490. I try to sync list of tables from one server to another with option "DropConstraintsAndIndexes" and "DisableKeys", but instead it just alter foreign keys with "NOCHECK CONSTRAINT". And that's why index on another table cant be dropped because it's related to that key. Sync fails with message " Error during sync: An explicit DROP INDEX is not allowed on index <index>. It is being used for FOREIGN KEY constraint enforcement"
LDC
0

Comments

1 comment

Sort by
  • sam.blackburn
    We've just released Data Compare 13.0.0.5042 to frequent updates, which drops foreign keys to allow other indexes to be dropped. Does this fix your problem?
    sam.blackburn
    0

Add comment

Please sign in to leave a comment.