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

SAP Sybase SQL Anywhere 16.0 » SQL Anywhere 16 - Changes and Upgrading » What's new in version 12.0.0


MobiLink new features

Following is a list of additions to MobiLink introduced in version 12.0.0. For information about supported platforms and versions, see [external link]

  • Central administration of remote databases   Central administration of remote databases can be used to do the following:

    • Centrally control when a remote database synchronizes with MobiLink. This was previously set on the client with dbmlsync option or hard-coded into an application.

    • Push schema changes to remote databases.

    • Help diagnose problems with specific remote databases or with the synchronization system in general.

    For information about central administration of remote databases, see Central administration of remote databases.

  • New MobiLink Replay utility (mlreplay)   The MobiLink Replay utility is a tool used to replay MobiLink protocol that is recorded by the MobiLink server. See MobiLink Replay utility (mlreplay).

  • MobiLink 12 plug-in for Sybase Central has been redesigned   The MobiLink plug-in has been redesigned in version 12 to support central administration of remote databases. The two MobiLink modes, Model and Admin, have been combined in the new plug-in. Now, you can use the MobiLink plug-in to create synchronization projects that contain consolidated databases, groups, synchronization models, and remote tasks. Old synchronization models can be imported into synchronization projects. See Central administration of remote databases.

  • Map consolidated columns to special values   You can now map consolidated columns to special values (such as the ML user) instead of remote columns.

  • Download delete subsets now supported   You can now specify download delete subsets, which by default are the same as the download subset.

  • New tree view allows selection of columns and tables   You can now choose the columns as well as the tables when creating or updating a consolidated database, or choosing tables to be synchronized in an existing remote database. To facilitate this, there is now a handy tree view of tables and columns where you can place checkmarks next to the tables and columns you want to synchronize.

  • Support for spatial data types   Synchronization models now support spatial data types and the TIMESTAMP WITH TIME ZONE data type.

  • Shadow tables now have indexes   Indexes are now created for any shadow tables that are created by the synchronization model. This can speed up download_delete_cursor and download_cursor scripts that use shadow tables.

  • SQL Anywhere Monitor now supports MobiLink server farms and Relay Server farms   Now, you can use the SQL Anywhere Monitor to monitor MobiLink server farms and Relay Server farms as well as SQL Anywhere databases and MobiLink servers. See SQL Anywhere Monitor.

  • New MobiLink arbiter server utility for server farms   For server-initiated synchronization the MobiLink arbiter ensures that only a single MobiLink server in a server farm is running as the primary server. See Architecture.

  • Enhanced support for server farms   New remote ID locking logic is used to prevent redundant synchronizations from the same remote ID in MobiLink high-availability. The -ss option no longer needs to be set. An arbiter is required when using server-initiated synchronization with a MobiLink server farm.


    Running the MobiLink server in a server farm is a feature of the MobiLink high availability option, which requires a separate license. See Separately licensed components.

  • TLS cipher suite support has changed   MobiLink server and clients now support 256-bit AES cipher suites for both RSA and ECC. Also, support has been added for the RFC 4492 version of the ECC cipher suites.

  • Dynamic memory caching   With dynamic memory caching, there is increased use of the memory cache so a larger cache may be needed to prevent swapping. Overall memory use should still be about the same.

  • New integrated Outbound Enabler   Use the new OE protocol for the -x option for mlsrv12 to use an integrated Outbound Enabler instead of the stand-alone Outbound Enabler invoked with the rsoe command. See -x mlsrv16 option.

  • New Relay Server plug-in for Sybase Central   There is a new Relay Server plug-in for Sybase Central that enables you to configure back-end farms and servers. The Relay Server plug-in is only supported on Windows and Linux. See Relay Server plug-in for Sybase Central.

  • Upload and download data script requirement   Use the ml_add_missing_dnld_scripts stored procedure to fix missing download_cursor and/or download_delete_cursor scripts. See ml_add_missing_dnld_scripts system procedure.

SQL statements
Consolidated databases
MobiLink server
Server utilities
MobiLink Monitor
MobiLink clients
Relay Server