What are the challenges you face when working across database platforms? Take the survey
Options

"DropConstraintsAndIndexes" doesnt drop constraint.

LDCLDC Posts: 2 New member
edited June 6, 2017 5:34AM in SQL Data Compare
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"
Tagged:

Comments

Sign In or Register to comment.