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_certificate or the e2ee_public_key option, the UltraLite runtime only looks for these files in the main resource bundle, which is a part of every iPhone application deployment package. You 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_certificate and e2ee_type.

The following options that were valid for versions 10 and earlier 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 are nopw part of 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_certificate
• UltraLite connection parameters
• UltraLite clients
• Supported exit codes
• MobiLink File Transfer utility (mlfiletransfer)

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_certificate=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_certificate=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_certificate=c:\clientcert.pem;e2ee_type=rsa;e2ee_public_key=c:\e2eepublic.pem}"