The begin_upload and end_upload scripts for each remote table hold logic that is independent of the individual rows being updated.

The upload consists of single row inserts, updates, and deletes. These actions are typically performed using upload_insert, upload_update, and upload_delete scripts.

To prepare the upload for SQL Anywhere clients, the dbmlsync utility requires access to all transaction logs written since the last successful synchronization. See Transaction log files.

When synchronizing a remote database using MobiLink client version 9.0 or earlier, or when using question marks instead of named parameters as placeholders in upload_insert, upload_new_row_insert, or upload_old_row_insert events, the MobiLink server uses the column order of the table as it is defined in the remote database. The column order in the event statement must match the column order as it is defined in the remote database but table and column names in the consolidated database can be different from those in the remote database.

The following is an INSERT statement used only when emp_name is defined before emp_id in the remote database.

INSERT INTO emp (emp_name, emp_id)
VALUES (?, ?);