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

SQL Anywhere 12.0.1 » Context-Sensitive Help » MobiLink plug-in help » MobiLink synchronization model wizards


Create Synchronization Model Wizard: Upload Conflict Resolution page

This page allows you to set the method of resolution for detected conflicts.

This page has the following components:

  • How do you want to resolve conflicts   Choose from the following options:

    • Consolidated database wins   Select this option to reject all uploaded updates from the remote database that conflict with the consolidated database.

    • Remote database wins   Select this option to accept all uploaded updates from the remote database, even if they conflict with the consolidated database. You should only use this option with column-based conflict detection. Otherwise, it is the same as not using conflict detection.

    • Newer wins, using a timestamp column that you maintain   Select this option to use a TIMESTAMP column to determine which changes should be accepted. This option applies only to tables that have a TIMESTAMP column.

      • Timestamp column   Choose the TIMESTAMP column from the dropdown list.

        This TIMESTAMP column must exist and its value must be maintained in both the remote and consolidated database tables. This option may require you to change your applications or use triggers to maintain the value.


        Do not choose the same column that is used by timestamp-based downloads. That column records the last time rows were changed on the consolidated database, and it should not be synchronized.

    • Custom conflict resolution   Select this option to use your own resolve_conflicts script. You can write the script in the Events tab after this wizard finishes. See Conflict resolution with resolve_conflict scripts.

You can view and modify these options in the Mappings tab after the Create Synchronization Model Wizard finishes. See Modifying conflict detection and resolution.

 See also