ulsync -c [ options ]  [synchronization parameters]

synchronize profileName merge 'syncOptions'

ulsync -p profileName "MobiLinkUid=ml;ScriptVersion=Version001...syncOptions"

When a certificate file is specified either with the trusted_certificates or the e2ee_public_key option, the UltraLite runtime will look for these files only in the main resource bundle, which is a part of every iPhone application deployment package. Add items to this bundle by including them in the /Resources folder in your xCode project. This is not applicable to certificates that are stored in the Ultralite database, and does not affect Mac OS clients (only iPhone). See trusted_certificatesand e2ee_type.

The following options that were valid for versions 10 and preceding are no longer supported: -a authenticate-parameters, -e sync-parms, -k stream-type, -n (no sync), and -x protocol options. -e <keyword>=<value> is now part of the sync parameters string and -k and -x have been folded into the Stream=<stream{<stream-parms>} sync parameters string.

ulsync can be considered to be equivalent to one the following SQL statements, depending on usage:

ulsync -p <profile> "<parms>"

is equivalent to:

 SYNCHRONIZE PROFILE <profile> MERGE
<parms>

and

ulsync "<parms>"

is equivalent to:

 SYNCHRONIZE USING <parms>

For secure synchronization, the UltraLite application must have access to the public certificate. You can reference a certificate by:

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

• Synchronization profile options
• End-to-end encryption
• trusted_certificates
• UltraLite connection parameters
• UltraLite clients
• Supported exit codes
• MobiLink File Transfer utility (mlfiletransfer)
• Deploy UltraLite with TLS-enabled synchronization

The following command synchronizes a database file called myuldb.udb for a MobiLink user called remoteA.

ulsync -c DBF=myuldb.udb "MobiLinkUid=remoteA;Stream=http;ScriptVersion=2"

The following command synchronizes a database file called myuldb.udb over HTTPS with the c:\certs\rsa.crt certificate. The trusted_certificates=file option must be used because the trusted certificate file was not added to the database when the database was created. Additionally, the MobiLink user name is remoteB.

ulsync -c DBF=myuldb.udb "Stream=https{trusted_certificates=c:\certs\rsa.crt};
MobiLinkUid=remoteB;ScriptVersion=2;UploadOnly=ON"

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

ulsync -r -c dbf=synced.udb

The previous synchronization results are listed as follows:

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

The following example shows the command line used to synchronize the CustDB database with a user name of 50 over TCP/IP on a port of 2439. It uses verbose progress messages.

ulsync -c "dbf=C:\Documents and Settings\All Users\Documents\SQL Anywhere 12\Samples\UltraLite\SyncEncrypt\custdb.udb" 
MobiLinkUid=50;ScriptVersion=custdb 12.0;Stream=tcpip{port=2439}

The following command illustrates how to use TLS encryption with E2EE:

ulsync -c "uid=dba;pwd=sql;dbf=myudb.db" "MobiLinkUid=rem1;MobiLinkPwd=password;ScriptVersion=v1;Stream=tls{host=myServer;port=2439;trusted_certificates=c:\clientcert.pem;e2ee_type=rsa;e2ee_public_key=c:\e2eepublic.pem}"