O'Reilly logo

Fundamentals of SQL Server 2012 Replication by Sebastian Meine

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 2: Configuring a Basic Replication Setup

The best way to get a feel for how SQL Server replication is implemented and how it works is to see it in action. In this chapter, we perform a set of exercises that walk you through a simple replication setup. The exercises demonstrate how to configure replication to copy a single table from one database to another database. To keep this setup simple, we'll use transactional replication and a single SQL Server instance to play the roles of Publisher, Distributor, and Subscriber. We'll also create the two publishing and subscribing databases as part of the exercises.

To set up replication, you must configure the Distributor and create a publication and a subscription. The easiest way to perform ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required