Inside a sync scope what order do tables sync?

[jantoineqci]

I have a sync scope with 10 tables. I list Table A before Table B and even alphabetically Table A becomes before Table B. Table B has FK to Table A. When I sync I get an error saying The FK value of Table B doesn't exists in Table A. What is the order of tables processed in a sync? or can I dictate the order in which the tables are processed?

[Mimetis]

The order is declared when you are creating your Setup
The order should always be "Parent" - "Child"

For instance, as example, your setup for AdventureWorks should be something like:

var setup = new SyncSetutp("Address", "Customer", "CustomerAddress");

Because we need the Address rows and Customer rows before creating the relations in CustomerAddress.
During sync, DMS is:

• Doing firstly the Update / Insert operation in the order of your declared tables.
• Doing secondly Delete operations in reverse order of your declared tables.

If you still have some foreign keys constraints issues, you can try the options DisableConstraintsOnApplyChanges

var options = new SyncOptions { DisableConstraintsOnApplyChanges = true };