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
| Discuss this page in DocCommentXchange. Send feedback about this page using email. |
Copyright © 2009, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.1 |