"DropConstraintsAndIndexes" doesnt drop constraint.
There is strange behavior in latest SQLDataCompare v184.108.40.20690. 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"
0 · Share on Twitter