This option allows you to specify the order in which tables are uploaded. You must specify all tables that are to be uploaded.
If you include tables that are not included in the synchronization, they are ignored.
The table order that you specify must ensure referential integrity. If Table1 has a foreign key reference to Table2, then
Table2 must be uploaded before Table1. If you do not specify tables in the appropriate order, an error occurs, except in the
two following cases:
You set TableOrderChecking=OFF.
Your tables have a cyclical foreign key relationship. (In this case, there is no order that satisfies the rule and so the
tables involved in the cycle can be uploaded in any order.)
If you do not specify TableOrder, then dbmlsync chooses an order that satisfies referential integrity.
The order of tables on the download is the same as the upload. Control of the upload table order may make writing server side
scripts simpler, especially if the remote and consolidated databases have different foreign key constraints.