MobiLink Synchronization User's Guide
Synchronization Techniques
Handling conflicts
Forced conflict resolution
If no upload_insert, upload_update, or upload_delete script is defined for a remote table, the MobiLink synchronization server uses forced conflict resolution . In this mode of operation, MobiLink synchronization server attempts to insert all uploaded rows from that table using the statements defined by the upload_old_row_insert and upload_new_row_insert scripts. In essence, all uploaded rows are then treated as conflicts. You can write stored procedures or scripts to process the uploaded values in any way you want.
Without any of the upload_insert, upload_update, or upload_delete scripts, the normal conflict-resolution procedure is bypassed. This technique has two principal uses.
Arbitrary conflict detection and resolution The automatic mechanism only detects errors when updating a row, and only then when the old values do not match the present values in the consolidated database.
You can capture the raw uploaded data using the upload_old_row_insert and upload_new_row_insert scripts, then process the rows as you see fit.
Performance When the upload_insert, upload_update, or upload_delete are not defined, the MobiLink synchronization server is relieved of its normal conflict-detection tasks, which involve querying the consolidated database one row at a time. Instead, it needs only to insert the raw uploaded information using the statements defined by the upload_old_row_insert and upload_new_row_insert scripts. Since only inserts are involved, the MobiLink synchronization server performs these inserts using bulk operations that are more efficient.