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

SQL Anywhere 10.0.1 » UltraLite - Database Management and Reference » UltraLite Utilities Reference

UltraLite Engine Stop utility (ulstop) Next Page

UltraLite Synchronization utility (ulsync)

Synchronizes an UltraLite database with a MobiLink server. It is a tool for testing synchronization during application development.


ulsync -c "connection-string" [ options ]

-a authenticate-parameters

Set any values required by your MobiLink server authenticate_parameters script. These may be a user name and password, for example. You can repeat this option to a maximum of 20 times, if required.

-c "connection-string"

Required. Connect to the database as identified in the DBF or file_name parameter of your connection-string. If you do not specify both a user ID and a password, the default UID of DBA and PWD of sql are assumed.

-e sync-parms

Set a single extended synchronization option. You can set multiple extended synchronization options with multiple -e options. The keywords are case insensitive. Note that you must always set Username and Version. For example:

-e Username=MyName -e Version=MyNum

See Extended synchronization parameters.

-k stream-type

Specify the synchronization stream, which can be encrypted or unencrypted. The stream-type must be one of tcpip, tls, http, or https. The default stream is tcpip.

For Palm OS, you must store the RSA certificate in the UltraLite database when it is created. For all other systems, you can specify the certificate file either with the -x trusted certificate=path option, or as an unnamed file with a certificate lookup mechanism that is part of the encryption code.


Do not carry out synchronization. Use this option with -r to see previous synchronization results.


Synchronize the database in read-only mode. UltraLite makes a copy of the original file, and then use the copy to test your scripts without altering the database. Changes to the copied file are discarded upon completion.

If you are connecting directly from the desktop to a database already deployed to a CE device, the parameter is not supported.


Display last synchronization results.


Run in quiet mode—do not print messages.


Display synchronization progress messages.

-x netopt-string

A semicolon-separated list of synchronization network protocol options (also known as stream parameters) and their respective values. See Network protocol options for UltraLite synchronization streams.

The default value is host=localhost.


Do not confuse the sync-parms option (which sets synchronization parameters) with the -x network protocol options option (which sets synchronization stream parameters).

This utility returns error codes. Any value other than 0 means that the operation failed.

See also

The following command synchronizes a database file named myuldb.udb. The MobiLink user name is remoteA.

ulsync -c DBF=myuldb.udb -k http -e "Username=remoteA;Version=2"

The following command uploads changes for a database file namedmyuldb.udb over HTTPS with the c:\certs\rsa.crt certificate. The MobiLink user name is remoteB.

ulsync -c DBF=myuldb.udb -k https -x trusted_certificate=c:\certs\rsa.crt 
-e "Username=remoteB;Version=2;UploadOnly=ON" 

The following command displays the last synchronization results for a database file named synced.udb.

ulsync -n -r -c dbf=synced.udb

The previous synchronization results are listed as follows:

 SQL Anywhere UltraLite Database Synchronize Utility Version 10.0
    Results of last synchronization:
        Download timestamp: 2006-07-25 16:39:36.708000
        Upload OK
        No ignored rows
        Partial download retained
        Authentication value: 1000 (0x3e8)