Introducing SQL Anywhere Studio
Replication Technologies
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 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