Skip to content

tutorial-replicating-data-with-mobile-clients.md

Latest commit

 

History

History
63 lines (44 loc) · 3.4 KB

tutorial-replicating-data-with-mobile-clients.md

File metadata and controls

63 lines (44 loc) · 3.4 KB
title Tutorial: Replicating Data with Mobile Clients | Microsoft Docs
ms.custom
ms.date 03/04/2017
ms.prod sql-server-2016
ms.reviewer
ms.suite
ms.technology
replication
ms.tgt_pltfrm
ms.topic get-started-article
applies_to
SQL Server 2016
helpviewer_keywords
replication [SQL Server], tutorials
ms.assetid af673514-30c7-403a-9d18-d01e1a095115
caps.latest.revision 24
author BYHAM
ms.author rickbyh
manager jhubbard

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 [!INCLUDEssManStudioFull] to create a publication. Later lessons show how to create and synchronize a subscription.

Requirements

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 [!INCLUDEssCurrent], except for Express ([!INCLUDEssExpress]) or [!INCLUDEssEW]. These editions cannot be a replication Publisher.

    • The [!INCLUDEssSampleDBobject] sample database. To enhance security, the sample databases are not installed by default..

  • Subscriber server (destination):

    • Any edition of [!INCLUDEssCurrent], except for [!INCLUDEssEW]. [!INCLUDEssEW] is not supported by the publication created in this tutorial.

    [!NOTE]
    Replication is not installed by default on [!INCLUDEssExpress].

Note

In [!INCLUDEssManStudioFull], 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

See Also

Replication Programming Concepts