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

Prerequisites for Merge Replication

As Merge Replication is the complex type of replication in terms of manageability, there are some points to be considered before we start with the installation of Merge Replication.

  • Unique identifier column: There should be a Globally Unique Identifier (GUID) column in every table that is to be published. If this column does not exist, it will get added by Merge Replication process; Merge Replication will also create a unique index on this column.
  • Timestamp columns: We should be extremely careful when replicating database(s) using Merge Replication, and especially with the Timestamp columns. Timestamp columns are supported, but the values of Timestamp will get regenerated when the snapshot is applied at the Subscriber ...

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