O'Reilly logo

Microsoft SQL Server 2008 High Availability by Hemantgiri S. Goswami

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

Installing Merge Replication

Let's now move ahead with the installation of Merge Replication. We have divided this into two parts — creating publication and creating subscription — to make it easy to understand.

Creating publication

  1. Connect to the server we wish to act as a publisher. Expand the server and expand the replication node. Right-click on the Publication and select New Publication.
    Creating publication

    Note

    We have a distributor created already; hence I am skipping that step here.

  2. On the Publication Database wizard screen, select the database that we wish to publish and click Next.
  3. On the Publication Type screen, select the Merge publication option and click on ...

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