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

SQL Anywhere 12.0.0 » Context-Sensitive Help » SQL Anywhere plug-in help » Introduction to SQL Anywhere properties windows

 

Synchronization Profile Properties window: Extended Options

This tab has the following components:

Extended options that are set in the following list are stored in the database. Dbmlsync combines options stored in the database with those specified on the command line. For information about how dbmlsync resolves conflicting options, see Priority order.

Option name Description
BufferDownload

Specifies whether the entire download from the MobiLink server should be read into the cache before applying it to the remote database. The default isTrue. See BufferDownload (bd) extended option.

ConflictRetries

Specifies the number of times dbmlsync retries the synchronization if the download fails because of conflicts. See ConflictRetries (cr) extended option.

DisablePolling

Disables automatic logscan polling. See DisablePolling (p) extended option.

ErrorLogSendLimit

Specifies how much of the remote log file dbmlsync should send to the MobiLink server when a synchronization error occurs. See ErrorLogSendLimit (el) extended option.

FireTriggers

Specifies that triggers should be fired on the remote database when the download is applied. See FireTriggers (ft) extended option.

HoverRescanThreshold

When you are using scheduling, this option limits the amount of discarded memory that is allowed to accumulate before a rescan is performed. See HoverRescanThreshold (hrt) extended option.

Increment

Enables incremental uploads and controls the size of upload increments. See Increment (inc) extended option.

LockTables

Specifies that tables in the publications being synchronized should be locked before synchronizing. See LockTables (lt) extended option.

MirrorLogDirectory

Specifies the location of old transaction log mirror files so that they can be deleted. See MirrorLogDirectory (mld) extended option.

NoSyncOnStartup

Prevents dbmlsync from synchronizing on startup when a scheduling option would otherwise cause that to happen. See NoSyncOnStartup (nss) extended option.

OfflineDirectory

Specifies the path containing offline transaction logs. See OfflineDirectory (dir) extended option.

PollingPeriod

Specifies the logscan polling period. See PollingPeriod (pp) extended option.

Schedule

Sets a schedule for synchronization. See Schedule (sch) extended option.

ScriptVersion

Specifies a script version. See ScriptVersion (sv) extended option.

SendColumnNames

Specifies that column names should be sent in the upload for use by direct row handling. See SendColumnNames (scn) extended option.

SendDownloadAck

Specifies that a download acknowledgement should be sent from the client to the MobiLink server. See SendDownloadAck (sa) extended option.

SendTriggers

Specifies that trigger actions should be sent on upload. See SendTriggers (st) extended option.

TableOrder

Sets the order of tables in the upload. Specify tables as a comma-separated list. You must specify all tables that are to be uploaded. If you include tables that are not included in the synchronization, they are ignored. See TableOrder (tor) extended option.

TableOrderChecking

Set this option to ON to make dbmlsync check that no table is uploaded before another table on which it has a foreign key. This option is only useful when the TableOrder extended option is specified. See TableOrderChecking (toc) extended option.