MSA extends Replication Server replication capabilities and can make the process of setting up a replication system both faster and easier.
Some of the features that MSA provides 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.
You can overlay MSA scenarios onto your existing replication structure. The procedures for implementing MSA are similar to those you already use to replicate to warm standby or replicate databases.
When you use table and function replication, you describe each piece of data that is to be replicated using individual table and function replication definitions and subscriptions. This methodology allows you to transform data and provides fine-grained control over the information being entered in the replicate database. However, you must mark each table or function to be replicated, create a replication definition for each replicated table or function, and create subscriptions for each replication definition at each replicate database.
MSA lets you identify specific database objects: tables, functions, transactions, DDL, and system stored procedures in a single replication definition. You can choose to replicate the entire database; or you can choose to replicate—or not replicate—specific tables, functions, transactions, DDL, and system stored procedures in that database. If you do not need to replicate partial tables, MSA can provide replication while affording the advantages of simple setup and maintenance.
In the non-MSA warm standby scenario, changes to the primary database are copied directly to the warm standby database without alteration. This methodology allows replication of DDL. To change or qualify the data sent, you must add table and function replication definitions. Each primary database can have one, and only one, standby database.
MSA provides all the features of traditional Sybase warm standby. In addition, MSA:
Enables replication to multiple standby databases
Provides the option to replicate or not replicate specific database objects
MSA supports the use of logical connections.
