VIII.5.3. Configuring Replication

Replication primarily occurs between two different systems (such as a server to a server or a server to a client), but it's also possible to replicate data between one database and another.

From a big picture perspective, replication is configured in three steps:

  1. Configure the publisher and distributor.

  2. Choose articles and create publications.

  3. Configure the subscriber.

We discuss each of these in turn throughout the rest of this section.

VIII.5.3.1. Configuring the publisher and distributor

In the following steps, you create a database and then configure the replication distributor and publisher.

  1. Launch SQL Server Management Studio (SSMS).

    Choose StartAll ProgramsMicrosoft SQL Server 2008SQL Server Management Studio.

  2. On the Connect to Server screen, click Connect.

  3. Click the New Query button to create a new query window.

  4. Enter and execute the following code to create a new database named ReplicateMe:

    USE Master;
    GO
    CREATE DATABASE ReplicateMe;
  5. Enter and execute the following code to create a table in your database:

    USE ReplicateMe; GO CREATE TABLE Employee ( EmployeeID int IDENTITY(100,1) NOT NULL, LastName varchar(35) NULL, FirstName varchar(35) NULL, CONSTRAINT ...

Get Microsoft® SQL Server™ 2008 All-In-One Desk Reference For Dummies® now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.