Tutorial: Replicating Data with Mobile Clients

Replication is a good solution to the problem of moving data between a central server and mobile clients that are only occasionally connected. Using replication's wizards, you can easily configure and administer a replication topology. This tutorial shows you how to configure a replication topology for mobile clients.

What You Will Learn

In this tutorial you will use merge replication to publish data from a central database to one or more mobile users so that each user gets a uniquely filtered subset of the data. The first lesson shows how to use SQL Server Management Studio to create a publication. Later lessons show how to create and synchronize a subscription.


This tutorial is intended for users familiar with fundamental database operations, but who have limited experience with replication. Before you start this tutorial, you must complete Tutorial: Preparing the Server for Replication.

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

  • At the Publisher server (source):

    • Any edition of SQL Server 2008, except for Express (SQL Server Express) or SQL Server Compact 3.5 SP1. These editions cannot be a replication Publisher.

    • The AdventureWorks sample database. To enhance security, the sample databases are not installed by default. For information about how to install the sample databases, see Considerations for Installing SQL Server Samples and Sample Databases.

  • Subscriber server (destination):

    • Any edition of SQL Server 2008, except for SQL Server Compact 3.5 SP1. SQL Server Compact 3.5 SP1 is not supported by the publication created in this tutorial.


    Replication is not installed by default on SQL Server Express.


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.