2 out of 2 rated this helpful - Rate this topic

Designing and Implementing: Tutorials (Replication)

SQL Server 2008

Replication includes tutorials that you can use to learn how to set up and run replication topologies using SQL Server Management Studio.

In the replication tutorials, "Publisher" refers to the server that contains that source data being replicated and "Subscriber" refers to the destination server. The Publisher and Subscriber may share the same instance of SQL Server, but it is not a requirement. For more information, see Replication Publishing Model Overview.

Note
Most of the tasks shown in these tutorials can be performed programmatically. For more information, see Developer's Guide (Replication).

Replication Tutorials

Preparing the Server for Replication: Learn how to prepare servers so that replication can be run with least privileges. You must complete this tutorial before the other replication tutorials.
Replicating Data Between Continuously Connected Servers: Learn how to use transactional replication to replicate data between fully connected servers.
Replicating Data with Mobile Clients: Learn how to use merge replication to exchange data between a server and one or more clients that are only occasionally connected.

Concepts

Replicating Data Between a Server and Clients

Other Resources

Replicating Data in a Server to Server Environment

Security and Protection (Replication)

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions

ADD