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

SQL Anywhere 11.0.0 » MobiLink - Client Administration » Introduction to SQL Anywhere Clients for MobiLink » SQL Anywhere clients » Initiating synchronization


Using dbmlsync extended options

MobiLink provides a number of extended options to customize the synchronization process. Extended options can be set for publications, users, and subscriptions. In addition, extended option values can be overridden using options on the dbmlsync command line.

For a complete list of extended options, see MobiLink SQL Anywhere client extended options.

To override an extended option on the dbmlsync command line

  • Supply the extended option values in the -e or -eu dbmlsync options for dbmlsync, in the form option-name=value. For example:

    dbmlsync -e "v=on;sc=low"

To set an extended option for a subscription, publication or user

  • Add the option to the CREATE SYNCHRONIZATION SUBSCRIPTION statement or CREATE SYNCHRONIZATION USER statement in the SQL Anywhere remote database.

    Adding an extended option for a publication is a little different. To add an extended option for a publication, use the ALTER/CREATE SYNCHRONIZATION SUBSCRIPTION statement and omit the FOR clause.


The following statement creates a synchronization subscription that uses extended options to set the cache size for preparing the upload to 3 MB and the upload increment size to 3 KB.

FOR ml_user
ADDRESS 'host=test.internal;port=2439;'
OPTION memory='3m',increment='3k'

Note that the option values can be enclosed in single quotes, but the option names must remain unquoted.

Dbmlsync network protocol options