Both MobiLink and SQL remote can provide data replication between a consolidated database and a set of remote databases.
The consolidated database contains all the data that you want to replicate. The remote database is a copy of the consolidated database that can be located at the same site as the consolidated database or at a physical remote site.
The following illustration shows a schematic diagram of a small system:
Schematic diagram of a small system
Remote user
The replication system includes many remote databases. Each remote database contains part of the information in the consolidated database. Each remote database is physically a separate database and is typically located on different computers. All remote databases must be aligned with the consolidated database.
You can treat the entire replication system as a decentralized database and save the master copy of all shared data in the consolidated database.
Each remote site that submits copies to the consolidated database can be considered a remote user of the consolidated database, and if the remote site is a multiuser server, the entire site can be considered a remote user of the consolidated database.
Hierarchy Database Configuration
Configure the parent database for the hierarchy, except for the consolidated database, which does not have a parent database.
Hierarchy Database Configuration
SQL Remote supports hierarchical configuration of databases, but Peer-to-peer replication or other unstructured configuration is not supported. Usually
It configures any two databases that share data directly in the hierarchy configuration, one of which is always above or below another database.
The remote database can contain tables that are not in the consolidated database, provided that the tables are not involved in replication. SQL remote requires that the table and column names in the remote database match the table names and column names in the consolidated database. Instead, MobiLink allows the remote and consolidated databases to store data in different columns and tables, thereby increasing flexibility.
Bidirectional replication
All Sybase replication Technologies provide bidirectional replication: The changes made in the consolidated database are propagated to the remote database, and changes made in the remote database are propagated to the consolidated database and then from the consolidated database to other remote databases. Sybase Replication server requires only one location to modify a piece of data. SQL Remote and MobiLink allow you to change the same data in multiple locations at the same time, and provide a way to resolve any conflicts.