Model Variations and Strategies

Model variations and other strategies are useful when implementing your replication system design.

Some of the model variations and strategies are:

Multiple replication definitions – a strategy using multiple replication definitions for a primary table to specify different table names, column sets, and column names, thereby presenting differing views of the primary table to subscribing replicate tables.
Publications – a strategy that allows users to subscribe to a set of replication definitions with a single subscription.
Pending tables – a strategy used with request functions that allows users to see the results of updates to primary data before the update has been returned to the replicate site.
Implementing master/detail relationships – uses request functions and stored procedures to ensure proper subscription migration.

Multiple Replication Definitions
You can create multiple replication definitions for a single primary table. Each replication definition can specify different table names, column sets, and column names, thereby presenting different views of the primary table to each of the subscribing replicate tables.
Publications
Use publications to collect replication definitions for tables and/or stored procedures and then subscribe to them as a group. Publication usage is not a separate model; it provides a grouping technique that can be used by any model. With publications, you can monitor the status of one publication subscription for a set of tables and procedures.
Request Functions
Request functions allow primary database users to invoke stored procedures on replicate data.
Master/Detail Relationships Implementation
You can use applied functions to replicate only selected data to remote sites, thus reducing network traffic.

Parent topic: Implementation Strategies