Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All

Tutorial: Replicating Data Between Continuously Connected Servers

Topic Status: Some information in this topic is preview and subject to change in future releases. Preview information describes new features or changes to existing features in Microsoft SQL Server 2016 Community Technology Preview 2 (CTP2).

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.

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, except Express (SQL Server Express) or SQL Server Compact. These editions cannot be replication Publishers.

    • AdventureWorks2012 sample database. To enhance security, the sample databases are not installed by default.

  • Subscriber server (destination):

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

    Note Note

    Replication is not installed on SQL Server Express by default.

Note Note

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.

Community Additions

ADD
Show:
© 2015 Microsoft