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

on delete cascade while datasynchronisation


Sometimes the SDK gives a foreign key error. Because the rows have references to other tables. Which is quite normal.

But is it possible to delete also these foreign rows at once?

Thank you in advance


  • Options
    Brian DonahueBrian Donahue Posts: 6,590 Bronze 1
    Hi Gillian,

    I believe you can fix this error easily by using the SqlOptions.DisableKeys option in your EngineDataCompareOptions class. Don't forget to specify this in mappings, session, and SqlProvider classes or you may see inconsistent behavior.

    Because SQL Data Compare Engine scripts updates a table at a time, it's necessary to temporarily disable the foreign keys and restore them after the synchronization.
Sign In or Register to comment.