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

SQL Anywhere 17 » MobiLink - Getting Started » MobiLink synchronization

Quick start to MobiLink

MobiLink is designed to synchronize data among many remote applications that connect intermittently with one or more central data sources.

In a basic MobiLink application, your remote clients are SQL Anywhere or UltraLite databases, and your central data source is one of the supported ODBC-compliant relational databases. This architecture can be extended using the MobiLink server API so that there are virtually no restrictions on what you synchronize to on the server side.

In all MobiLink applications, the MobiLink server is the key to the synchronization process. Synchronization typically begins when a MobiLink remote site opens a connection to a MobiLink server. During synchronization, the MobiLink client at the remote site can upload database changes that were made to the remote database since the previous synchronization. On receiving this data, the MobiLink server updates the consolidated database, and then can download changes from the consolidated database to the remote database.

The quickest way to start developing a MobiLink application is to use the Create Synchronization Model Wizard. When you use the wizard, most of the steps outlined below are handled for you.

However, even when using a MobiLink model, you need to understand the process and components of MobiLink synchronization.

Overview of a MobiLink application
  • Set up a consolidated database

    Run setup scripts against the database to add system objects required by MobiLink synchronization. Alternatively, you can create a separate system database to hold these objects.

  • Set up remote databases

    • Your remote databases can be SQL Anywhere, UltraLite, or a combination of the two.
    • In your remote databases, create MobiLink users.
    • To determine the upload in a SQL Anywhere remote database, create publications and subscriptions. To determine the upload in an UltraLite remote database, create publications.
  • Create server synchronization logic to determine how the upload is applied.

  • Set up timestamp-based synchronization to download data that has changed since the last download.

  • Start the MobiLink server.

  • Initiate synchronization on the client.

Introductory reading

Refer to the MobiLink - Getting Started book for introductory information about MobiLink.

The MobiLink- Server Administration book also contains information to help you get started with MobiLink, including topics on synchronization techniques and writing scripts.


The following tutorials range from introductory tutorials for news users to demonstrations of how to use advanced features.

  • CustDB sample for MobiLink
  • MobiLink Contact sample
  • Tutorial: Introducing MobiLink
  • Tutorial: Using MobiLink with a SQL Anywhere consolidated database
  • Tutorial: Building the UltraLite CustDB sample application
  • Tutorial: Using MobiLink with an Oracle Database 11g
  • Tutorial: Using MobiLink with an Adaptive Server Enterprise consolidated database
  • Tutorial: Using Java or .NET for custom user authentication
  • Tutorial: Using direct row handling
  • Tutorial: Synchronizing with Microsoft Excel
  • Tutorial: Synchronizing with XML
  • Tutorial: Using central administration of remote databases
  • Tutorial: Changing a schema using the script version clause
  • Tutorial: Changing a schema using the ScriptVersion extended option
  • Tutorial: Simulating multiple MobiLink clients using the MobiLink Replay utility
Other resources for getting started
  • MobiLink provides samples that you can examine and run to explore MobiLink functionality. MobiLink samples are installed with the product in %SQLANYSAMP17%\MobiLink.

  • The SAP SQL Anywhere Community has links to blogs maintained by executives, employees, and developers who exchange views and ideas about using SQL Anywhere, MobiLink, and related technologies.