MobiLink Synchronization User's Guide
Writing Synchronization Scripts
To upload information contained in your remote database to your consolidated database, you define upload scripts. You write separate scripts to handle rows that are updated, inserted, or deleted at the remote database. A simple implementation would carry out corresponding actions (update, insert, delete) at the consolidated database.
The MobiLink synchronization server uploads data in a single transaction. For a description of the upload process, see Events during upload.
The begin_upload and end_upload scripts for each remote table hold logic that is independent of the individual rows being updated.
The upload stream 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 Adaptive Server Anywhere clients, the dbmlsync utility requires access to all transaction logs written since the last successful synchronization. For more information, see Transaction log files.
Writing upload_insert scripts
Writing upload_update scripts
Writing upload_delete scripts
Writing upload_fetch scripts