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

SQL Anywhere 12.0.0 » Context-Sensitive Help » MobiLink Plug-in help » MobiLink synchronization model wizards


Create Synchronization Model Wizard: Timestamp Download Options page

Timestamp-based downloads require a timestamp column for each synchronized table in the consolidated database to track when changes are made to rows.


The timestamp column records the last time synchronization changes were made in the consolidated database. This column resides on the consolidated database, and it should never be synchronized or changed by another process.

This page allows you to specify the name of the timestamp column, and whether the column should be added to synchronized tables or whether shadow tables should be created to hold the timestamp.

This page has the following components:

Timestamp column name   Shows the name of the timestamp column.

Use timestamp columns in synchronized tables   Select this option to add timestamp columns to your synchronized tables on the consolidated database. Choose this option if you are willing to change the consolidated table definition. When you deploy the model, a timestamp column is added to each synchronized table in the consolidated database if it does not already exist.

If you try to redeploy this model to the consolidated database, you are prompted to update the consolidated schema in the model.

Use shadow tables to hold timestamp columns   Select this option if you want to create a shadow table for each synchronized consolidated database table. Select this option if you don't want to modify the schema of the synchronized consolidated database by adding timestamp columns. The shadow tables have two columns, one holding the primary key for the table, and the other holding the timestamp. Shadow tables are created with the same owner as the base table.

You can view and modify these options, after the Create Synchronization Model Wizard finishes, in the Mappings tab. See Modifying the download type.

 See also