Tutorial: Replicating Data Between Continuously Connected Servers

New: 17 July 2006

Replication is a good solution to the problem of moving data between continuously connected servers. Using replication's wizards, you can easily configure and administer a replication topology. This tutorial shows you how to configure a replication topology for continuously connected servers.

What You Will Learn

This tutorial will show you how to publish data from one database to another using transactional replication. The first lesson shows how to use SQL Server Management Studio to create a publication. Later lessons show how to create and validate a subscription and how to measure latency.


This tutorial is intended for users who are familiar with basic database operations, but who have limited experience with replication. This tutorial requires that you have completed the previous tutorial, Preparing the Server for Replication.

To use this tutorial, your system must have the following components:

  • At the Publisher server (source):

    • Any edition of SQL Server 2005, except SQL Server 2005 Express Edition (SQL Server Express) or SQL Server Compact Edition (SQL Server 2005 Compact Edition). These editions cannot be replication Publishers.
    • AdventureWorks sample database. To enhance security, the sample databases are not installed by default. To install the sample databases, see Running Setup to Install AdventureWorks Sample Databases and Samples.
  • Subscriber server (destination):

    • Any edition of SQL Server 2005, except SQL Server 2005 Compact Edition. SQL Server 2005 Compact Edition cannot be a Subscriber in transactional replication.


    Replication is not installed on SQL Server Express by default. For information about installing replication, see How to: Install Replication During SQL Server Express Setup. The Publisher and Subscriber can share the same instance of SQL Server 2005.


In SQL Server Management Studio, you must connect to the Publisher and Subscriber using a login that is a member of the sysadmin fixed server role.

Estimated time to complete this tutorial: 30 minutes.

Lessons in This Tutorial

Start the Tutorial


For reviewing tutorials we recommend that you add Next and Previous buttons to the document viewer toolbar. For more information, see Adding Next and Previous Buttons to Help.

See Also

Other Resources

Implementing Replication Overview
Planning for Replication Programming

Help and Information

Getting SQL Server 2005 Assistance