How to create a merge publication (Transact-SQL)

To create a publication (merge)

1. Execute sp_replicationdboption to enable publication of the current database.
2. Execute sp_addmergepublication to define the publication.
3. Execute sp_addpublication_snapshot to create a Snapshot Agent, set the publication agent_id value, and place the schema and data into the replication working directory.
4. Execute sp_addmergearticle n times to define each article in the publication.

See Also