Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 10.0.1 » SQL Anywhere Server - SQL Usage » Working with Database Objects » Working with databases

Setting database options Next Page

Specifying a consolidated database

In Sybase Central, you can specify the consolidated database for SQL Remote replication. The consolidated database is the one that serves as the master database in the replication setup. The consolidated database contains all of the data to be replicated, while its remote databases can only contain their own subsets of the data. In case of conflict or discrepancy, the consolidated database is considered to have the primary copy of all data.

For more information, see Consolidated and remote databases.

To set a consolidated database (Sybase Central)
  1. Select the desired database and then choose File > Properties.

  2. Click the SQL Remote tab.

  3. Select the This Remote Database Has a Corresponding Consolidated Database option.

  4. Configure the desired settings.