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.
Discuss this page in DocCommentXchange.
|Copyright © 2012, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.1|