Replication Examples

The examples in this section show you how to:

• Set up servers in basic replication roles and establish replication relationships between those servers
• Replicate a table from one server to another
• Filter a published table so that only specified rows and columns are replicated
• Restrict a publication so that it can be seen by and can be replicated to only a selected list of servers
• Reduce the replication load on the publication server by setting it up to use a separate distribution server
• Selectively subscribe a subscription server to a subset of the available publications
• Replicate a table locally, to another database on the publication server

In general, each succeeding example builds on the replication configuration established by the previous examples. For this reason, it is a good idea to review the examples in sequence.

For information, choose one of the following topics.

Setting Up A Replication Topology

Replicating a Table

Replicating a Partitioned Table

Restricting a Publication

Using a Remote Distributor

Selectively Subscribing to Data

Replicating a Table Locally