This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
Applies to: 
SQL Server
Azure SQL Managed Instance
Replication is a powerful solution for moving data, or subsets of data, between servers. You can replicate data between servers that are fully connected by using transactional replication. You can also replicate data between servers and clients that are intermittently connected by using merge replication. In this article, you will find tutorials that help prepare your server for replication, and then teach you to configure both transactional and merge replication.
In the replication tutorials, "publisher" refers to the server that contains the source data that's being replicated. "Subscriber" refers to the destination server. The publisher and subscriber might share the same instance of SQL Server, but it is not a requirement. For more information, see the overview of the replication publishing model.
These tutorials use NODE1\SQL2016 as the publisher and distributor. They use NODE2\SQL2016 as the subscriber.
Note
Most of the tasks shown in these tutorials can be performed programmatically. For more information, see the replication developer documentation.
Tutorial: Prepare SQL Server for replication (publisher, distributor, subscriber)
Learn how to prepare servers so that replication can be run with least privileges. You must complete this tutorial before the other replication tutorials.
Tutorial: Configure replication between two fully connected servers (transactional)
Learn how to configure transactional replication to replicate data between fully connected servers. This tutorial also includes some basic error troubleshooting methodology.
Tutorial: Configure replication between a server and mobile clients (merge)
Learn how to configure merge replication to exchange data between a server and one or more clients that are only occasionally connected.
Training
Learning path
Design and implement a replication strategy for Azure Cosmos DB for NoSQL - Training
Design and implement a replication strategy for Azure Cosmos DB for NoSQL
Certification
Microsoft Certified: Azure Database Administrator Associate - Certifications
Administer an SQL Server database infrastructure for cloud, on-premises and hybrid relational databases using the Microsoft PaaS relational database offerings.
Documentation
Tutorial: Configure Transactional Replication - SQL Server
This tutorial teaches you how to configure Transactional Replication between two fully connected SQL Server instances.
Tutorial: Configure Merge Replication - SQL Server
This tutorial teaches you how to configure Merge Replication between a SQL Server and a mobile client.
Tutorial: Prepare for replication - SQL Server
In this tutorial, learn how to prepare your publisher, distributor, and subscriber for replication by creating Windows accounts, preparing the snapshot folder, and configuring distribution.