Contents Index Benefits of data replication Consolidated and remote databases

Introducing SQL Anywhere Studio
   Replication Technologies
    Introduction

Challenges for replication technologies


Any replication technology must address several challenges that arise as a result of the increased flexibility permitted by replication.

Transactional integrity 

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.

Data consistency 

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.


Contents Index Benefits of data replication Consolidated and remote databases