Using multisite availability (MSA), you create a single database replication definition to describe the data to be sent to the replicate database. The database replication definition describes the database objects that are to be replicated. You can choose to replicate, or not replicate, individual tables, transactions, functions, system stored procedures, and DDL.
You then create a single database subscription at each subscribing database for the data described in the database replication definition. Database subscriptions cannot limit the data copied.
MSA provides a simple replication methodology that requires only one replication definition for the primary database and only one subscription for each subscribing database. If you want to transform the data, replicate minimal columns, or use primary keys to improve performance, you must add table and function replication definitions. See Chapter 12, “Managing Replicated Objects Using Multisite Availability,” for more information.
