|
Synchronization profiles allow you to place some dbmlsync options in the database. The synchronization profile you create can contain a variety of synchronizations options.
Synchronization profiles can be created, altered and dropped using the following statements:
Synchronization profiles can be accessed using the dbmlsync -sp option, the Sync method in the Dbmlsync API, the SQL SYNCHRONIZE statement and the remote tasks created from central administration of remote databases. In all cases there is the ability to specify additional options that are merged with the options in the synchronization profiles. If any of the extra option specified conflicts with an option specified in the synchronization profile, the value specified by the extra options is used.
When using the dbmlsync -sp options, all the other options on the command line are treated as extra options. The other interfaces provide a specific parameter or clause for specifying extra options.
The following options can be specified in a synchronization profile:
| Long option name | Short name | Allowed values | Description |
|---|---|---|---|
| AuthParms | ap | String | Supplies parameters to the authenticate_parameters script and to authentication parameters. |
| ApplyDnldFile | ba | String | Applies a download file. |
| Background | bk | String | Enables background synchronization when set to TRUE. |
| BackgroundRetry | bkr | Integer | Controls how dbmlsync behaves after a background synchronization is interrupted. |
| ContinueDownload | dc | Boolean | Restarts a previously failed download. |
| CreateDnldFile | bc | String | Creates a download file. |
| DnldFileExtra | be | String | When creating a download file, this option specifies an extra string to be included in the file. |
| DownloadOnly | ds | Boolean | Performs a download-only synchronization. |
| DownloadReadSize | drs | Integer | For restartable downloads, specifies the maximum amount of data that may need to be re-sent after a communications failure. |
| ExtOpt | e | String | Specifies extended options. |
| IgnoreHookErrors | eh | Boolean | Ignores errors that occur in hook functions. |
| IgnoreScheduling | is | Boolean | Ignores scheduling instructions so that synchronization is immediate. |
| KeepPartialDownload | kpd | Boolean | In the event of a download failure, saves the information required to attempt restarting the failed download. |
| KillConnections | d | Boolean | Drops conflicting locks to the remote database. |
| LogRenameSize | x | An integer optionally followed by K or M | Renames and restarts the transaction log after it has been scanned for upload data. |
| MobiLinkPwd | mp | String | Supplies the password of the MobiLink user. |
| MLUser | u | String | Specifies the MobiLink user name. |
| NewMobiLinkPwd | mn | String | Supplies a new password for the MobiLink user. Use this option when you want to change an existing password. |
| Ping | pi | Boolean | Pings a MobiLink server to confirm communications between the client and MobiLink. |
| Publication | n | String | This option is deprecated. Specifies the publications(s) to synchronize. Publication can only be specified once in a synchronization profile but the command line option can be specified multiple times. |
| RemoteProgressGreater | ra | Boolean | Specifies that the remote offset should be used if it is greater than the consolidated offset. This is equivalent to the -ra option. |
| RemoteProgressLess | rb | Boolean | Specifies that the remote offset should be used if it is less than the consolidated offset (such as when the remote database has been restored from backup). This is equivalent to the -rb option. |
| Subscription | s | String | Specifies the subscription(s) to synchronize. Subscription can only be specified once in a synchronization profile. |
| TransactionalUpload | tu | Boolean | Specifies that each transaction on the remote database should be uploaded as a separate transaction within one synchronization. |
| UpdateGenNum | bg | Boolean | When creating a download file, this option creates a file that can be used with remote databases that have not yet synchronized. |
| UploadOnly | uo | Boolean | Specifies that synchronization only includes an upload, and that no downloads occur. |
| UploadRowCnt | urc | Integer | Specifies an estimate of the number of rows to be uploaded in a synchronization. |
| Verbosity | String (a comma-separated list of options) |
Controls dbmlsync verbosity. Similar to the Verbose MobiLink SQL Anywhere client extended option. The value must be a comma-separated list of one or more of the following options, each of which corresponds to an existing -v option described below:
|