MobiLink article property sheets contain all the standard article tabs, along with the Upload and Download tabs, the properties of which are listed below:
Upload Tab
The following properties are available on the Upload tab:
|
Property
|
Description
|
|
Upload
|
Specifies the method for determining the data to upload to the remote databases. You have to select or specify the following values:
-
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 how conflicts will be resolved 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 uploaded data.
-
Last win – last user who uploaded data.
-
User-defined – specifies a resolution script written by an administrator to manage a conflict resolution.
|
Download Tab
The following properties are available on the Download tab:
|
Property
|
Description
|
|
Enable download
|
Specifies the method for determining the data to download from the consolidated database. You can choose one of the following values:
-
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 – tracks changes to records. You have to use triggers to manage the contents of the shadow table. Specify the name of the shadow table. <ConsolidatedTable> represents the code of the consolidated table.
-
Use snapshot – retrieves all the records.
|
|
Enable download delete
|
Specifies the method for determining the list of deleted records. You can choose one of the following values:
-
Use deleted column – specifies the column name, data type, and the deleted value and non-deleted value designators.
-
Use shadow table – tracks deleted records. You have to use triggers to manage the contents of the shadow table. Specify the name of the deleted shadow table (<ConsolidatedTable> represents the code of the consolidated table), along with the timestamp column name.
|
|
Enable data partitioning
|
Specifies the column name to store the synchronization user name for data partitioning.
|