on delete cascade while datasynchronisation

Hello,

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
Gillian

Comments

  • 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.