MobiLink Synchronization User's Guide
Synchronization Techniques
The chapter Writing Synchronization Scripts describes how to write simple synchronization scripts, store them in your database, and test that they are free of syntax errors.
Many useful synchronization features require not just one script, but a set of scripts working together. This chapter describes how to implement some common synchronization techniques. The examples describe SQL synchronization scripts. You can also use Java or .NET synchronization logic, although the upload and download events still require a knowledge of the SQL scripts.
The timestamp-based synchronization of the Customer table used in the Contact sample application requires the following scripts:
An upload_insert script to handle new rows added at remote databases at the consolidated database.
An upload_update script to handle modifications made at remote databases at the consolidated database.
An upload_delete script to handle rows deleted from remote databases at the consolidated database.
A download_cursor script to download new and updated rows to remote databases.
A download_delete_cursor script to download rows to be deleted from remote databases.