Contents Index Setting database options Displaying system objects in a database

ASA SQL User's Guide
  Working with Database Objects
    Working with databases

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 may 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. Right-click the desired database and choose Properties from the popup menu.

  2. Click the SQL Remote tab.

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

  4. Configure the desired settings.


Contents Index Setting database options Displaying system objects in a database