Introducing SQL Anywhere Studio
Tutorial: Replicating Data with SQL Remote
Data replication is the sharing of data among physically distinct databases. Changes made to shared data in any one database are replicated in the other databases. Sybase provides three distinct strategies for data replication:
SQL Remote
MobiLink
Replication Server
SQL Remote is designed for two-way replication involving a consolidated data server and a very large number of remote databases, typically including many mobile databases. Administration and resource requirements at the remote sites are minimal. This system is message-based.
In a SQL Remote installation, the central database must be either Sybase Adaptive Server Anywhere or Sybase Adaptive Server Enterprise.
SQL Remote replicates data by scanning the transaction log and preparing messages, as appropriate, for each transaction. It orders these messages and sends them to the remote or consolidated site. When processing received messages, SQL Remote always processes them in the same order as they were applied to the other database. When necessary, it automatically delays processing a message until all earlier messages have been applied.
For more information about synchronization strategies, including complete SQL Remote documentation, see the About This Manual.
For an introduction to MobiLink synchronization, see Tutorial: Synchronizing Databases with MobiLink.