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.
Most of the tasks shown in these tutorials can be performed programmatically. For more information, see the replication developer documentation.
Learn how to prepare servers so that replication can be run with least privileges. You must complete this tutorial before the other replication tutorials.
Learn how to configure transactional replication to replicate data between fully connected servers. This tutorial also includes some basic error troubleshooting methodology.
Learn how to configure merge replication to exchange data between a server and one or more clients that are only occasionally connected.