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

SQL Anywhere 11.0.1 » SQL Remote » SQL Remote Replication Design » SQL Remote replication design and set up » Update conflicts


Default resolution for update conflicts

Update conflicts only occur when data is being updated at more than one site. For example:

  1. User 1 updates a row at remote site 1.

  2. User 2 updates the same row at remote site 2.

  3. The update from User 1 is sent and applied to the consolidated database.

  4. The update from User 2 is sent to the consolidated database.

    The default method for resolving this type of update conflict is the following:

    1. The more recent operation (in this example that from User 2) succeeds. It becomes the value in the consolidated database and it is the value that is replicated to all other databases subscribed to that row.

    2. All other updates (in this example that from User 1) are lost.

    3. No report is made of the conflict.

Conflict resolution, with the second update overwriting the first.