Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Import/Export (DTS) and Replication (2000)
 Merge replication with a faster snapshot

Author  Topic 

sql_er
Constraint Violating Yak Guru

267 Posts

Posted - 2007-06-18 : 17:44:03
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
   

- Advertisement -