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

SQL Anywhere 17 » UltraLite - Database Management and Developer Guide » UltraLite database reference » UltraLite utilities

UltraLite synchronization profile options

Specify synchronization profile options with the ulsync utility on the command line after you have defined all other command line options. 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 synchronization to fail. The default value is "no."
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.
CheckpointStore Boolean Adds additional checkpoints of the database during synchronization to limit database growth during the synchronization process.
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.
DisableConcurrency Boolean Disallow database access from other threads during synchronization.
DownloadOnly Boolean Performs a download-only synchronization.
KeepPartialDownload Boolean Controls whether UltraLite keeps a partial download if a communication error occurs. By default, UltraLite does not roll back partially downloaded changes.
MobiLinkPwd String Specifies the existing MobiLink password associated with the user name.
MobiLinkUid String Specifies the MobiLink user name.
NewMobiLinkPwd String Supplies a new password for the MobiLink user. Use this option when you want to change an existing password.
Ping Boolean Confirms communications with the server only; no synchronization is performed.
Publications String (comma separated) Specifies the publications(s) to synchronize. The publications determine the tables on the remote database 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.
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.
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.
Stream String (with sub-list) Specifies the MobiLink network synchronization protocol.
TableOrder String (comma separated) Specifies the order of tables in the upload. By default, UltraLite selects an order based on foreign key relationships.
UploadOnly String Specifies that synchronization will only include an upload, and no download will occur.

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.