SQL Anywhere Studio Help
Adaptive Server Anywhere Help
Introduction to property sheets
Template property sheet, Definition property sheet, and Site property sheet
The Extended Options tab of the Template, Definition, and Site property sheets has the following components:
Extended option | Default | Description |
---|---|---|
ConflictRetries (cr) extended option | -1 (continue indefinitely) | Specifies the number of retries if the download fails because of conflicts. |
FireTriggers (ft) extended option | ON | Specifies that triggers should be fired on the remote database when the download is applied. |
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. |
OfflineDirectory (dir) extended option | NULL | Specifies the path containing offline transaction logs. |
Schedule (sch) extended option | No schedule | Specifies a schedule for synchronization. |
ScriptVersion (sv) extended option | DEFAULT | Specifies a script version. |
SendTriggers (st) extended option | OFF | Specifies that trigger actions should be sent on upload. |
StreamCompression (sc) extended option | Medium | Compress upload data stream: choose LOW, MEDIUM, or HIGH. |
TableOrder (tor) extended option | (none) | Specifies the order of tables in the upload stream. |
Verbose (v) extended option | OFF | Specifies full verbosity. |