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

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