MobiLink Article Properties

Use timestamp column – compares values in a timestamp column. You must specify the name of the column that will contain this information. By default, the timestamp column name specified in the MobiLink Options tab of the replication process is used.

Use shadow table – the shadow table tracks changes to records. You have to use triggers to manage the contents of the shadow table. You can also specify the name of the shadow table. <ConsolidatedTable> represents the code of the consolidated table.

Use snapshot – retrieves all the records.

Use deleted column – you must specify the column name, data type, and the deleted value and non-deleted value designators.

Use shadow table – you have to use triggers to manage the contents of the shadow table. You must specify the name of the deleted shadow table (<ConsolidatedTable> represents the code of the consolidated table), along with the timestamp column name.

Enable insert – Specifies the upload of inserted data in the remote database.

Enable update – Specifies the upload of updated data in the remote database.

Enable delete – Specifies the upload of deleted data in the remote database.

Enable conflict resolution – Specifies the resolution of conflicts during the upload. You must specify the name of the tables that will store new and old data rows and the resolution type, which can take one of the following values:

First win – first user who synchronized.

Last win – last user who synchronized.

User-defined – an administrator has to write a resolution script, as a conflict cannot automatically resolve.