Contents Index SendTriggers (st) extended option UploadOnly (uo) extended option

MobiLink Synchronization Reference
  MobiLink Synchronization Client
    dbmlsync options
      -e extended options

TableOrder (tor) extended option

Function 

Specifies the order of tables in the upload stream.

Syntax 

dbmlsync -e tor= tables ; ...

Description 

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.

See also 

Referential integrity and synchronization

Example 

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';

Contents Index SendTriggers (st) extended option UploadOnly (uo) extended option