Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 11.0.1 » MobiLink - Server Administration » Using MobiLink Server Technology » Synchronization techniques


Uploading data from self-referencing tables

Some tables are self-referencing. For example, an employee table may contain a column that lists employees and a column that lists the manager of each employee, and there may be a hierarchy of managers managing managers. These tables can pose a challenge to synchronization because the MobiLink default behavior is to coalesce all data updates on the remote database, which is efficient but which loses the order of transactions.

There are two techniques for handling this situation:

  • If you are using a SQL Anywhere remote database, you can use the dbmlsync -tu option to specify that each transaction on the remote should be sent as a separate transaction.

    See -tu option.

  • Add a mapping table so the order of transactions doesn't matter.