MobiLink Synchronization Reference
MobiLink Synchronization Client
dbmlsync options
-e extended options
Specifies the order of tables in the upload stream.
dbmlsync -e tor= tables ; ...
This option allows you to specify the order of tables that are to be uploaded. Specify tables as a comma-separated list. You must specify all tables that are to be uploaded. If you list tables that are not included in the synchronization, they are ignored.
Specify table order to ensure referential integrity. For example, if Table1 refers to Table2, then Table2 must be uploaded before Table1.
In the specified table order, no table may have a foreign key that refers to a table that comes after it in the table order, unless your tables have a cyclical foreign key relationship. By default, dbmlsync selects a table order that satisfies this condition.
There are no cases where this option must be used. It is provided for users who for some reason (usually because it makes their scripts simpler on the consolidated database) would like to ensure that tables are uploaded in a specific order.
This option has a short form and long form: you can use tor or TableOrder.
You can also store extended options in the database. For more information about dbmlsync extended options, see -e extended options.
Referential integrity and synchronization
The following dbmlsync command line illustrates how you can set this option when you start dbmlsync:
dbmlsync -e "tor=admin,parent,child"
The following SQL statement illustrates how you can store this option in the database:
CREATE SYNCHRONIZATION SUBSCRIPTION TO sales_publication FOR ml_user1 OPTION tor='admin,parent,child';