SQL Server Performance Forum – Threads Archive
Any way to skip snapshot in merge replication?Guys, I am considering to set up a merge replication. The issue is that the tables I plan to replicate are too big (~50GB) in total. I think that snapshot agent will take forever to copy them over to the subscriber. Is there a way to avoid this [i.e. maybe restore the database at the subscriber] and then somehow make the necessary tables part of the merge replication. Please advise Thanks a lot
You can backup and restore the databse or manually copy the tables and when you configure the subscription choose the option "Subscriber has the schema and data" to avoid snapshot…
SQL-Server-Performance.com All postings are provided â€œAS ISâ€ with no warranties for accuracy.
If the link between them is good then you could take help of dynamic snapshothttp://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/mergperf.mspx andhttp://www.sql-server-performance.com/merge_replication.asp too. KBAhttp://support.microsoft.com/kb/320499 on what Mohammed referred. Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.
Mohammed – thanks for the useful info Satya – thanks for the great links – i skimmed through – they look very useful – will read in more details once implementing