SEO
vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
02-29-2008, 04:40 AM
| ||||
| ||||
 Not applying the initial snapshot when setting up Tran Repl. I am setting up a combination of transactional and merge replication on a very large database and do not want to apply the initial snapshot since this would take to long. I am doing this with scripts that were previosly created when the database was not this big. I want to copy the publisher DB over to the Subscriber Server. Can I use the parameter @sync_type to 'none' when running the sp_addsubscription? Does anyone have any experience in doing this? Thanks in Advance for any help on this. Alan      |
|
02-29-2008, 04:41 AM
| |||
| |||
| Re: Not applying the initial snapshot when setting up Tran Repl. Hi Alan, I do not know how to use the parameter with sql script. But you can do it using Enterprise Manager. When creating subscription, just let it know that the subcriber already has data. You can then generate the script of the publication and subscription to see how to use script to do the same thing. One caution, if you do not create initial snapshot, you may have to create sp_msdel..., sp_msIns .. sp_msup.. stored procedures in the subscription database used by the replication. Hope it helps, -Mokles "Alan F." <alan.frush@healthtrio.com> wrote in message news:7fbe9ceb.0410270828.3daed8f0@posting.google.c om... > I am setting up a combination of transactional and merge replication > on a very large database and do not want to apply the initial snapshot > since this would take to long. I am doing this with scripts that were > previosly created when the database was not this big. I want to copy > the publisher DB over to the Subscriber Server. Can I use the > parameter @sync_type to 'none' when running the sp_addsubscription? > Does anyone have any experience in doing this? > > Thanks in Advance for any help on this. > > Alan |
|
02-29-2008, 04:42 AM
| ||||
| ||||
| Re: Not applying the initial snapshot when setting up Tran Repl. Unfortunately I am using existing scripts generated by the DBA before me. I have done it using EM but just need to figure out how to do it via T-SQL. Thanks, Alan *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! |
Linear Mode
