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.
- 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.
We have a distributor created already; hence I am skipping that step here.
- On the Publication Database wizard screen, select the database that we wish to publish and click Next.
- On the Publication Type screen, select the Merge publication option and click on ...