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

SQL Anywhere 12.0.0 (Français) » UltraLite - Database Management and Reference » UltraLite database reference » UltraLite utilities


Synchronization profile options

You specify synchronization profile options with the ulsync utility on the command line after you have defined all other command line options you want to use. The keywords are case insensitive.

Synchronization profile option Valid values Description
AllowDownloadDupRows Boolean This option prevents errors from being raised when multiple rows are downloaded that have the same primary key. This can be used to allow inconsistent data to be synchronized without causing the synchronisation to fail. The default value is "no." See Additional Parameters synchronization parameter
AuthParms String (comma separated) Specifies the list of authentication parameters sent to the MobiLink server. You can use authentication parameters to perform custom authentication in MobiLink scripts. See Authentication Parameters synchronization parameter.
CheckpointStore Boolean Adds additional checkpoints of the database during synchronization to limit database growth during the synchronization process. See Additional Parameters synchronization parameter.
ContinueDownload Boolean Restarts a previously failed download. When continuing a download, only the changes that were selected to be downloaded with the failed synchronization are received. By default, UltraLite does not continue downloads. See Resuming failed downloads.
DisableConcurrency Boolean Disallow database access from other threads during synchronization. See Additional Parameters synchronization parameter.
DownloadOnly Boolean Performs a download-only synchronization. See Download Only synchronization parameter.
KeepPartialDownload Boolean Controls whether UltraLite keeps a partial download if a communication error occurs. By default, UltraLite does not roll back partially downloaded changes. See Keep Partial Download synchronization parameter.
MobiLinkPwd String Specifies the existing MobiLink password associated with the user name. See MobiLinkPwd (mp) extended option.
MobiLinkUid String Specifies the MobiLink user name. See -u dbmlsync option (deprecated). See -mn dbmlsync option.
NewMobiLinkPwd String Supplies a new password for the MobiLink user. Use this option when you want to change an existing password. See -mn dbmlsync option.
Ping Boolean Confirms communications with the server only; no synchronization is performed. See Ping synchronization parameter.
Publications String (comma separated) Specifies the publications(s) to synchronize. The publications determine the tables on the remote that are involved in synchronization. If this parameter is blank (the default) then all tables are synchronized. If the parameter is an asterisk (*) then all publications are synchronized. See Publications in UltraLite.
ScriptVersion String Specifies the MobiLink script version. The script version determines which scripts are run by MobiLink on the consolidated database during synchronization. If you do not specify a script version, 'default' is used. See ScriptVersion (sv) extended option.
SendColumnNames String Specifies that column names should be sent to the MobiLink server as part of the upload file when synchronizing. By default, column names are not sent. See Send Column Names synchronization parameter.
SendDownloadACK Boolean Specifies that a download acknowledgement should be sent from the client to the server. By default, the MobiLink server does not provide a download acknowledgement. See Send Download Acknowledgement synchronization parameter.
Stream String (with sub-list) Specifies the MobiLink network synchronization protocol. See Stream Type synchronization parameter.
TableOrder String (comma separated) Specifies the order of tables in the upload. By default, UltraLite selects an order based on foreign key relationships. See Additional Parameters synchronization parameter.
UploadOnly String Specifies that synchronization will only include an upload, and no download will occur. See Upload Only synchronization parameter.

The Boolean values can be specified as Yes/No, 1/0, True/False, On/Off. In all the Boolean cases, the default is No. For all other values, the default is simply unspecified.

 See also