Replication tutorials

APPLIES TO: yesSQL Server noAzure SQL Database noAzure SQL Data Warehouse noParallel Data Warehouse

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.

Replication tutorials

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.

See also

Security and protection for replication

Transactional replication overview

Merge replication overview