Set Up an MSA System

You can set up MSA replication using different ways.

Set up representative MSA replication architectures:

To replicate DDL or system stored procedures, you can easily add syntax when you are setting up these architectures.

• Replicating the Database in a Simple Scenario
  Use database replication definitions and subscriptions to replicate the entire primary database to one or more replicate databases in this simple scenario.
• Replicating Tables and Functions
  Use MSA capabilities to replicate particular tables or functions.
• Using Replicate Databases as Warm Standby Databases
  Use MSA to replicate DDL and other database objects to multiple replicate or warm standby databases.