Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SAP Sybase SQL Anywhere 16.0 » MobiLink - Client Administration » SQL Anywhere clients for MobiLink » Scripted upload


Scripted upload setup

The following steps provide an overview of the tasks required to set up scripted upload, assuming that you already have MobiLink synchronization set up.


When using scripted upload, it is strongly recommended that you use the default setting for the dbmlsync extended option LockTables.

You can avoid many problems with scripted uploads by using the default setting for LockTables, which causes dbmlsync to obtain locks on all synchronization tables before the upload is built. This prevents other connections from changing the synchronization tables while your scripts are building the upload. It also ensures that there are no uncommitted transactions that affect synchronization tables open while your scripts are building the upload.

  1. Create stored procedures that identify the rows to upload   You can define three stored procedures per table: one each for upload, insert, and delete.

    See Stored procedures for scripted upload.

  2. Create a publication that contains the keywords WITH SCRIPTED UPLOAD and that specifies the names of the stored procedures   See Publications for scripted upload.

 Other resources for getting started