Monday, July 30, 2007

Merge Replication

It uses two agents: snapshot and merge agent.

Active Directory Accounts: VIP\SnapshotAgent and VIP\MergeAgent.

Publisher database:

Login: VIP\SnapshotAgent and VIP\MergeAgent
Database user: VIP\SnapshotAgent belongs to db_owner
VIP\MergeAgent must have SELECT, INSERT, DELETE, and UPDATE permissions on the published articles. I assign the VIP\MergeAgent to be a member of db_datareader and db_datawriter.

Distributor database:
Login: VIP\SnapshotAgent and VIP\MergeAgent
Database user: VIP\SnapshotAgent belongs to db_owner
MergeAgent can be mapped to the Guest user of the Distribution database.

Default Snapshot Folder (UNC path): \\Server\Data
VIP\SnapshotAgent --Write permission
VIP\MergeAgent--Read permission

Publication Access List: VIP\MergeAgent must be in the list.

Subscriber:

Pull subscription: VIP\MergeAgent database user belongs db_owner role.

From a subscriber, you create a subscription. It should not have any problem.

In merge replication, the net result instead of log data is used.