"DropConstraintsAndIndexes" doesnt drop constraint.

LDC

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"

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?