Contents Index Challenges for replication technologies Hierarchical database configurations

Introducing SQL Anywhere Studio
   Replication Technologies

Consolidated and remote databases


Both MobiLink and SQL Remote provide data replication between a consolidated database and a set of remote databases.

A consolidated database is a database that contains all the data to be replicated. A remote database is a copy of the consolidated database that may be running either at the same site as the consolidated database or at a physically distant site.

The figure displays a schematic illustration of a small installation.

A single consolidated database and a set of remote databases.
Remote users 

A replication installation includes many remote databases. Each remote database contains a subset of the information in the consolidated database. Each remote database is a physically separate database, usually on a separate computer. All remote databases must stay consistent with the consolidated database.

The entire replication setup may be considered a single dispersed database, with the master copy of all shared data being kept at the consolidated database.

Each remote site that submits replications to the consolidated database is considered to be a remote user of the consolidated database. In the case that a remote site is a multi-user server, the entire site is considered to be a single remote user of the consolidated database.


Hierarchical database configurations
Two-way replication

Contents Index Challenges for replication technologies Hierarchical database configurations