Not applying the initial snapshot when setting up Tran Repl.

[Alan F.]

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

[mokles]

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." <al********@healthtrio.com> wrote in message
news:7f**************************@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

[Alan Frush]

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!