Master Database Replication

The master database controls the operation of Adaptive Server and stores information about every user database and associated database devices.

You can replicate the master database, although only the Data Definition Language (DDL) and system commands used to manage logins and roles are replicated. Master database replication does not replicate data from system tables, data or procedures from any other user tables in the master database.

Both the source Adaptive Server and the target Adaptive Server must have the same hardware architecture type (32-bit versions and 64-bit versions are compatible) and the same operating system (different versions are also compatible).

For a list of supported DDL and system procedures that apply to master database, see the Replication Server Administration Guide Volume 2.

Replication Server 12.0 and later supports master database replication with warm standby, and with MultiSite Availability (MSA) in Replication Server 12.6 and later. The primary or active Adaptive Server must be Adaptive Server 15.0 ESD #2 and later.

See the Replication Server Administration Guide Volume 1 for information about master database replication in MSA, and the Replication Server Administration Guide Volume 2 for information about master database replication in a warm standby environment.