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 ...