Multisite Availability

Multisite Availability (MSA) extends Replication Server replication capabilities and simplifies setting up a replication system.

Key features of MSA include:

A simple replication methodology that requires only one replication definition for the primary database and only one subscription for each subscribing database.
A replication filtering strategy that lets you choose whether or not to replicate individual tables, transactions, functions, system stored procedures, and data definition language (DDL).
Replication of DDL to any replicate database—including non–warm standby databases. Replication to multiple replicate sites—for standby as well as nonstandby databases.

Multisite Availability Diagram
The diagram illustrates a simple example of multisite availability replication.
Adding the Primary Database to the Replication Server
Add a primary database to the Replication Server for MSA.
Adding the Replicate Database to the Replication Server
Add a replicate database to the Replication Server for MSA.
Marking the Primary Database for Replication
Use database replication definition and subcription to replicate the entire primary database.
Replicating DDL
Replicate DDL.
Replicating DML
Replicate DML.