title

Replication Tutorials | Microsoft Docs

ms.custom

ms.date

04/09/2018

ms.prod

sql

ms.prod_service

database-engine

ms.service

ms.component

replication

ms.reviewer

ms.suite

sql

ms.technology

replication

ms.tgt_pltfrm

ms.topic

article

applies_to

SQL Server 2016

helpviewer_keywords

tutorials [SQL Server replication]

walkthroughs [SQL Server replication]

replication [SQL Server], tutorials

ms.assetid

19fbd10e-5b59-4cd0-a988-52d5d9206242

caps.latest.revision

author

MashaMSFT

ms.author

mathoma

manager

craigg

ms.workload

On Demand

Replication Tutorials

[!INCLUDEappliesto-ss-xxxx-xxxx-xxx-md] Replication is a powerful solution for moving data, or subsets of data, between servers. You can replicate data between servers that are fully connected using Transactional Replication. You can also replicate data between servers and clients that are intermittently connected using Merge Replication. Below, 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 that source data being replicated and "Subscriber" refers to the destination server. The Publisher and Subscriber may share the same instance of [!INCLUDEssNoVersion], but it is not a requirement. For more information, see Replication Publishing Model Overview.

These tutorials use NODE1\SQL2016 as the Publisher and Distributor, and NODE2\SQL2016 as the Subscriber.

Note

Most of the tasks shown in these tutorials can be performed programmatically. For more information, see Replication Developer Documentation.