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

SQL Anywhere 11.0.1 » SQL Anywhere 11 - Introduction » SQL Anywhere 11 Overview » Overview of data exchange technologies


Comparing synchronization technologies

Data exchange technologies include synchronization, replication, messaging, and mobile web service technologies.

Data synchronization is the sharing of data among physically distinct databases. When an application modifies shared data at any one database, the changes are propagated to other databases in the synchronization system. Changes can be propagated by various means and through a variety of channels, allowing flexible application architecture while preserving data integrity.

SQL Anywhere offers two synchronization technologies:

  • MobiLink   is a session-based technology intended for the one- or two-way synchronization of data between a central, consolidated database and a large number of remote databases. It supports a variety of consolidated database servers, and provides an API for synchronizing with virtually any other data source. Administration and resource requirements at the remote sites are minimal, making MobiLink well suited to a variety of mobile applications. At the end of each synchronization session, the databases are consistent.

  • SQL Remote   is a message-based technology intended for the two-way replication of database transactions. It is designed for two-way replication involving a consolidated data server and large number of remote databases. Administration and resource requirements at the remote sites are minimal, making SQL Remote well suited to mobile databases.

The following table summarizes the characteristics of MobiLink and SQL Remote.

Synchronization technology Number of databases Connection Frequency Consolidated database types
MobiLink Large Occasional Medium Many options
SQL Remote Large Occasional Low SQL Anywhere

MobiLink characteristics
SQL Remote characteristics
Benefits of data synchronization
Challenges for synchronization technologies
Consolidated and remote databases
Hierarchical database configurations
Two-way synchronization
Propagation methods