Introducing SQL Anywhere Studio
Replication Technologies
Introduction
Any replication technology must address several challenges that arise as a result of the increased flexibility permitted by replication.
One of the challenges of any replication system is to ensure that each database retains transactional integrity at all times.
Replication Server and SQL Remote replicate portions of the transaction log in such a way that transactions are maintained during replication: either a whole transaction is replicated, or none of it is replicated. This ensures transactional integrity at each database in the setup.
MobiLink consolidates changes made in multiple, committed transactions. These changes are applied to another database in a single transaction.
Another challenge to replication systems is to maintain data consistency throughout the setup. Replication systems maintain a loose consistency in the setup as a whole: that is, all changes are replicated to each site over time in a consistent manner, but different sites may have different copies of data at any instant.