Replication Tutorials

New: 17 July 2006

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 2005, but it is not a requirement. For more information, see Replication Publishing Model Overview.


Most of the tasks shown in these tutorials can be performed programmatically. For more information, see Replication Programming.

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.

See Also

Other Resources

Replicating Data in a Server to Server Environment
Replicating Data Between a Server and Clients
Security Considerations for Replication

Help and Information

Getting SQL Server 2005 Assistance