on delete cascade while datasynchronisation
Authorized_
Posts: 7
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
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
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.