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|
|SQL Remote||Large||Occasional||Low||SQL Anywhere|
SQL Remote characteristics
Benefits of data synchronization