DC generates script with multiple drop/add FK constraints

PeterPeter Posts: 9
SQL Server 2000 SP3
Data Compare

When comparing two DBs I noticed strange behavior of Sync wizard: I start sync wizard, save sql script, cancel sync wizard, and reopen sync wizard again. Then the sync wizard is creating duplicated drop/add statements for some of the FK constraints. If I repeat this opening/canceling sync wizard I get one more drop/create statment each time.

Such sql script will fail ofcourse.

If this is a known bug I hope it will be solved soon, if not then I can post some more info and/or screenshots.
Peter Reskovic
Hermes SoftLab


This discussion has been closed.