Row-based conflict detection   A conflict is detected if the row has been updated by both the remote and consolidated databases since the last synchronization.

This option defines an upload_fetch script and upload_update script. See Conflict detection with upload_fetch or upload_fetch_column_conflict scripts.

Column-based conflict detection   A conflict is detected if the same column has been updated for the row in both the remote and consolidated databases.

This option defines an upload_fetch_column_conflict script. See Conflict detection with upload_fetch or upload_fetch_column_conflict scripts.

If a table has BLOBs and you choose column-based conflict detection, row-based conflict detection is used.

Consolidated   First in wins: uploaded updates that conflict are discarded.

Remote   Last in wins: uploaded updates are always applied.

Timestamp   The newest update wins. To use this option, you must create and maintain a TIMESTAMP column for the table. This TIMESTAMP column should record the last time that a row was changed. The column should exist on both the consolidated and remote databases and not be the same column used for timestamp-based downloads. To work, your remote and consolidated databases must use the same time zone (preferably UTC) and their clocks must be synchronized.

Custom   You write your own resolve_conflict scripts. You do this on the Events tab. See Conflict resolution with resolve_conflict scripts.