MobiLink clients

Following is a list of enhancements to MobiLink clients introduced in SQL Anywhere version 12.0.0.

Dbmlsync has enhanced support for background synchronization The database engine can now drop the dbmlsync connection to the remote database (and rollback uncommitted operations dbmlsync has) if another connection is waiting for access to any database resource that dbmlsync has locked. This allows the other connection to go forward without waiting for the synchronization to complete.
Use these options for background synchronization:
- -bk dbmlsync option
- -bkr dbmlsync option
- Background and BackgroundRetry options for MobiLink synchronization profiles
dbmlsync now supports named subscriptions The new -s option for dbmlsync allows you to specify the names of subscriptions to be synchronized. See -s dbmlsync option.
HTTP response buffering Use the new network protocol option http_buffer_responses to completely stream HTTP packets from MobiLink into an intermediary buffer before being processed instead of processing the bytes as they are read off the wire. See http_buffer_responses.
Client-side certificates can now be used to authenticate MobiLink clients to third party servers and proxies The identity and identity_password synchronization parameters have been added to provide support for this feature.
Synchronization no longer required to implement schema changes on remote databases (for SQL Anywhere clients only) You can simplify schema changes on the remote database by using the START and STOP SYNCHRONIZATION SCHEMA CHANGE statements to delimit your schema change. See:
- START SYNCHRONIZATION SCHEMA CHANGE statement [MobiLink]
- STOP SYNCHRONIZATION SCHEMA CHANGE statement [MobiLink]
Use the CREATE or ALTER SYNCHRONIZATION SUBSCRIPTION statement to specify a script version for each synchronization subscription. See:
- CREATE SYNCHRONIZATION SUBSCRIPTION statement [MobiLink]
- ALTER SYNCHRONIZATION SUBSCRIPTION statement [MobiLink]
New mlfileupload method for UltraLite The MLFileUpload method has been added for UltraLite clients.
Changes to the dbmlsync options window The following changes have been made to the dbmlsync options window:
- Retry on remote progress, Remote is behind, Remote is ahead, Drop conflicting connections, Site Script, and Cmdline help have been removed.
- The Publication option has been replaced with a Subscription option.

New dbmlsync options

New -s option for dbmlsync Use the new -s option for dbmlsync to specify the names of the subscriptions to be synchronized. See -s dbmlsync option.
New -bk option for dbmlsync This option enables background synchronization. See -bk dbmlsync option.
New -bkr option for dbmlsync This option controls the behavior of dbmlsync after a background synchronization is interrupted. See -bkr dbmlsync option.
New -ci option for dbmlsync This option is part of the new dynamic cache sizing feature. Use this option to set the initial size of the cache used by dbmlsync for synchronization data. See -ci dbmlsync option.
New -cl option for dbmlsync This option is part of the new dynamic cache sizing feature. Use this option to set the minimum size to which the dbmlsync cache file will be reduced. See -cl dbmlsync option.
New -cm option for dbmlsync This option is part of the new dynamic cache sizing feature. Use this option to set the maximum size limit for the dbmlsync cache file. See -cm dbmlsync option.
New BufferDownload extended option for dbmlsync This option is part of the new dynamic cache sizing feature. The option specifies whether the entire download from the MobiLink server should be read into the cache before applying it to the remote database. See BufferDownload (bd) extended option.

New Dbmlsync C++ API objects

CancelSync method This method allows MobiLink clients to cancel a synchronization. See DbmlsyncClient.CancelSync method [Dbmlsync C++].
DBSC_CancelRet enumeration This enumeration indicates the result of a synchronization cancellation attempt. See DBSC_CancelRet enumeration [Dbmlsync C++].
DBSC_ERR_ACTIVE_SYNC_NOT_CANCELED member This member indicates that the server could not cancel the synchronization request because the synchronization was active. See DBSC_ErrorType enumeration [Dbmlsync C++].
DBSC_ERR_DEAD_SERVER member This member indicates that the dbmlsync server encountered an error while starting up and is shutting down. See DBSC_ErrorType enumeration [Dbmlsync C++].
"enable status" property Three new events (DBSC_EVENTTYPE_ML_CONNECT, DBSC_EVENTTYPE_UPLOAD_COMMITTED, and DBSC_EVENTTYPE_DOWNLOAD_COMMITTED) are sent to the MobiLink client when this property is enabled. See DBSC_EventType enumeration [Dbmlsync C++], DbmlsyncClient.SetProperty method [Dbmlsync C++] and DbmlsyncClient.GetProperty method [Dbmlsync C++].

New Dbmlsync .NET API objects

CancelSync method This method allows MobiLink clients to cancel a synchronization. See DbmlsyncClient.CancelSync method [Dbmlsync .NET].
DBSC_CancelRet enumeration This enumeration indicates the result of a synchronization cancellation attempt. See DBSC_CancelRet enumeration [Dbmlsync .NET].
DBSC_ERR_ACTIVE_SYNC_NOT_CANCELED member This member indicates if the server could not cancel the synchronization request if the synchronization was active. See DBSC_ErrorType enumeration [Dbmlsync .NET].
DBSC_ERR_DEAD_SERVER member This member indicates that the dbmlsync server encountered an error while starting up and is shutting down. See DBSC_ErrorType enumeration [Dbmlsync .NET].
"enable status" property Three new events (DBSC_EVENTTYPE_ML_CONNECT, DBSC_EVENTTYPE_UPLOAD_COMMITTED, and DBSC_EVENTTYPE_DOWNLOAD_COMMITTED) are sent to the MobiLink client when this property is enabled. See DBSC_EventType enumeration [Dbmlsync .NET], DbmlsyncClient.SetProperty method [Dbmlsync .NET] and DbmlsyncClient.GetProperty method [Dbmlsync .NET].

New client utilities features

Upload files using mlfiletransfer You can now upload files using the mlfiletransfer utility. See MobiLink File Transfer utility (mlfiletransfer).
New -i option for mlfiletransfer utility The -i option was added to mlfiletransfer to disable resume functionality. See MobiLink File Transfer utility (mlfiletransfer).

Discuss this page in DocCommentXchange.