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.

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

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

  • Subscriber server (destination):

    • Any edition of SQL Server 2012, except for SQL Server Compact. SQL Server Compact is not supported by the publication created in this tutorial.
    System_CAPS_ICON_note.jpg Note

    Replication is not installed by default on SQL Server Express.

System_CAPS_ICON_note.jpg 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.

Start the Tutorial

Replication Programming Concepts