Extended options can be specified on the dbmlsync command line using the -e or -eu options, or they can be stored in the database. You store extended options in the database by using Sybase Central, by using the sp_hook_dbmlsync_set_extended_options event hook, or by using the OPTION clause in any of the following statements:
Dbmlsync combines options stored in the database with those specified on the command line. If conflicting options are specified, dbmlsync resolves them as follows. In the following list, options specified by methods occurring earlier in the list take precedence over those occurring later in the list.
This priority order also affects connection parameters, such as those specified with the TYPE and ADDRESS options in the SQL statements mentioned above.
You can review extended options in the log and the SYSSYNC system view.
For information about how extended options can be used to tune synchronization, see Using dbmlsync extended options.
The following dbmlsync command line illustrates how you can set extended options when you start dbmlsync:
dbmlsync -e "adr=host=localhost;dir=c:\db\logs"...
The following SQL statement illustrates how you can store extended options in the database:
CREATE SYNCHRONIZATION SUBSCRIPTION TO mypub FOR mluser ADDRESS 'host=localhost' OPTION schedule='weekday@11:30am-12:30pm', dir='c:\db\logs'
The following dbmlsync command line opens the usage screen that lists options and their syntax:
|Send feedback about this page via email or DocCommentXchange||Copyright © 2008, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.0|