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.

Example

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. 

CREATE SYNCHRONIZATION SUBSCRIPTION TO my_pub
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

Copyright © 2008, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.0