SQL Anywhere Studio Help
Adaptive Server Anywhere Help
Introduction to property sheets
Publication property sheet
The Extended Options tab of the Publication property sheet has the following components:
This publication has the following MobiLink extended options Lists the extended options and values set for the publication. Click the Value field beside the option name to set the value for the publication.
The table below lists all the available extended options for synchronization.
For more information about these options, see -e extended options.
| Extended option | Default | Description |
|---|---|---|
| CommunicationAddress (adr) extended option | '' |
Specifies the communication address for connecting to the MobiLink server.
For allowed values, see CREATE SYNCHRONIZATION USER statement [MobiLink]. |
| CommunicationType (ctp) extended option | '' |
Specifies the communication type for connecting to the MobiLink server.
For allowed values, see CREATE SYNCHRONIZATION USER statement [MobiLink]. |
| ConflictRetries (cr) extended option | -1 (continue indefinitely) | Specifies the number of retries if the download fails because of conflicts. |
| DisablePolling (p) extended option | OFF | Disables automatic logscan polling. |
| DownloadBufferSize (dbs) extended option | 32 K on Windows CE, 1 M on all other operating systems. |
Specifies the size of the download buffer.
By default, units of bytes are used. You can use the suffix k or m to to specify units of kilobytes or megabytes, respectively. |
| DownloadOnly (ds) extended option | OFF | Specifies that synchronization should be download-only. |
| ErrorLogSendLimit (el) extended option | 32 K |
Specifies how much of the remote log file dbmlsync should send to the server when synchronization occurs.
By default, units of bytes are used. You can use the suffix k or m to to specify units of kilobytes or megabytes, respectively. If you don't want to send any dbmlsync output log messages, a zero value should be set for this extended option. |
| FireTriggers (ft) extended option | ON | Specifies that triggers should be fired on the remote database when the download is applied. |
| HoverRescanThreshold (hrt) extended option | 1 M |
When you are using scheduling, this limits the amount of discarded memory that is allowed to accumulate before a rescan is performed.
By default, units of bytes are used. You can use the suffix k or m to to specify units of kilobytes or megabytes, respectively. |
| IgnoreHookErrors (eh) extended option | OFF | Specifies that errors that occur in hook functions should be ignored. |
| IgnoreScheduling (isc) extended option | OFF | Specifies that scheduling settings should be ignored. |
| Increment (inc) extended option | (infinite) |
Controls the size of incremental uploads.
By default, units of bytes are used. You can use the suffix k or m to to specify units of kilobytes or megabytes, respectively. |
| LockTables (lt) extended option | ON | Specifies that articles (tables or parts of tables in the publications being synchronized) should be locked before synchronizing. |
| Memory (mem) extended option | 1 M |
Specifies a cache size.
By default, units of bytes are used. You can use the suffix k or m to to specify units of kilobytes or megabytes, respectively. |
| MobiLinkPwd (mp) extended option | NULL | Specifies the MobiLink password. |
| NewMobiLinkPwd (mn) extended option | NULL | Specifies a new MobiLink password. |
| OfflineDirectory (dir) extended option | NULL | Specifies the path containing offline transaction logs. |
| PollingPeriod (pp) extended option | 1 minute |
Specifies the logscan polling period.
By default, units of minutes are used. You can use the suffix s, m, h, or d to specify units of seconds, minutes, hours, or days, respectively. |
| Schedule (sch) extended option | No schedule | Specifies a schedule for synchronization. |
| ScriptVersion (sv) extended option | DEFAULT | Specifies a script version. |
| SendColumnNames (scn) extended option | OFF | Specifies that column names should be sent in the upload. |
| SendDownloadACK (sa) extended option | OFF | Specifies that a download acknowledgement should be sent from the client to the server. |
| SendTriggers (st) extended option | OFF | Specifies that trigger actions should be sent on upload. |
| TableOrder (tor) extended option | (none) | Specifies the order of tables in the upload stream. |
| UploadOnly (uo) extended option | OFF | Specifies that synchronization should only include an upload. |
| Verbose (v) extended option | OFF |
Specifies full verbosity.
This option is identical to dbmlsync -v+. |
| VerboseHooks (vs) extended option | OFF |
Specifies that messages related to hook scripts should be logged.
This option is identical to dbmlsync -vs. |
| VerboseMin (vm) extended option | OFF |
Specifies that a small amount of information should be logged.
This option is identical to dbmlsync -v. |
| VerboseOptions (vo) extended option | OFF |
Specifies that information should be logged about the command line options (including extended options) that you have specified.
This option is identical to dbmlsync -vo. |
| VerboseRowCounts (vn) extended option | OFF |
Specifies that the number of rows that are uploaded and downloaded should be logged.
This option is identical to dbmlsync -vn. |
| VerboseRowValues (vr) extended option | OFF |
Specifies that the values of rows that are uploaded and downloaded should be logged.
This option is identical to dbmlsync -vr. |
| VerboseUpload (vu) extended option | OFF |
Specifies that information about the upload stream should be logged.
This option is identical to dbmlsync -vu. |
You can set extended options for synchronization in the following ways:
on the dbmlsync command line using the -e or -eu options
in Sybase Central
using the following SQL statements:
CREATE SYNCHRONIZATION SUBSCRIPTION
ALTER SYNCHRONIZATION SUBSCRIPTION
CREATE SYNCHRONIZATION USER
ALTER SYNCHRONIZATION USER
CREATE SYNCHRONIZATION SUBSCRIPTION without specifying a synchronization user (this associates extended options with a publication)
When you store extended options and connection parameters in the database, dbmlsync reads the information from the database. If values are specified in both the database and the command line, the value strings are combined. If conflicting values are specified, dbmlsync resolves them as follows, where values occurring earlier in the list take precedence over those occurring later in the list:
dbmlsync extended option -eu
dbmlsync extended option -e
specified on the subscription (whether by a SQL statement or in Sybase Central)
specified on the MobiLink user (whether by a SQL statement or in Sybase Central)
specified on the publication (whether by a SQL statement or in Sybase Central)
For example, if you specify FireTriggers=OFF using the -e option on the command line, and you specify FireTriggers=ON for the publication, synchronization is attempted using the -e option setting (FireTriggers=OFF).
If a field is blank on the Extended Options tab of the Publication property sheet, the publication may be inheriting the extended option value from the -e option, the -eu option, the synchronization subscription, or the MobiLink user. You should only supply extended option values on the Extended Options tab of the Publication property sheet if you want to override these other values.