Replication Definitions for Database Objects

You can use multisite availability (MSA) to 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 or if a table needs to have a different replicate minimal columns or dynamic SQL setting than the target connection, you must add table and function replication definitions.

Related concepts
Manage Replicated Objects Using Multisite Availability