Tutorial: Configure replication between a server and mobile clients (merge)

Tutorial: Configure replication between a server and mobile clients (merge)

  • 04/03/2018
  • 9 minutes to read

Applies to: SQL Server (all supported versions)

Merge replication is a good solution to the problem of moving data between a central server and mobile clients that are only occasionally connected. By using the replication wizards, you can easily configure and administer a merge replication topology.

This tutorial shows you how to configure a replication topology for mobile clients. For more information about merge replication, see the overview of merge replication.

What you will learn

This tutorial teaches you to 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.

In this tutorial, you will learn how to:

  • Configure a publisher for merge replication.
  • Add a mobile subscriber for merge publication.
  • Synchronize the subscription to the merge publication.

  Link to PDF : Diagnose and resolve latch contention on SQL Server