Search code examples
sqlsql-serversql-server-2008replicationmerge-replication

Copy snapshot files from Publisher, Paste and Apply on subscriber in SQL Merge Replication

I read an excellent article about copying the snapshot files for Transactional replication from Publisher to Subscriber and Apply them on subscriber.

http://blogs.msdn.com/b/repltalk/archive/2010/03/07/tips-to-improve-performance-when-applying-snapshot-in-transactional-replication.aspx

But the focus of this article is directed to Transactional Replication.

I want to know how we can copy the snapshots from publisher, paste them on the subscriber and apply them on subscriber. I am using Merge Replication with push subscriber, Distributor and Publisher are on the same server.

Solution

  • Yes - With Merge we can copy the snapshot files to the Subscriber and apply the snapshot locally using the Merge Agent -AltSnapshotFolder parameter.