all groups > sql server replication > october 2003 >
You're in the

sql server replication

group:

Merge Relpication Scripting..


Merge Relpication Scripting.. mka
10/14/2003 4:06:05 PM
sql server replication:
Hi,

I have a problem with droping and recreating Merge Replication using scripts (created from the Enterprise Manager).

Do I need to drop the Distributer as well using the script?. and recreate again?
OR
It is not required to drop the Distributer..(I have problem If I dont drop the Distributer)

Is there any way to drop and recreate the Merge Replication without dropping the Distributer using the scripts.(It works in when I use GUI. Thru' Enterprise Manager I dont need to drop the Distributer )

Thanks in advance
mka

Merge Relpication Scripting.. Hilary Cotter
10/15/2003 9:34:34 AM
You don't have to drop the distributor.

When you script out a publication normally the creation of
the distribution database is not included in your script.
[quoted text, click to view]
Replication using scripts (created from the Enterprise
Manager).
[quoted text, click to view]
Replication without dropping the Distributer using the
scripts.(It works in when I use GUI. Thru' Enterprise
Manager I dont need to drop the Distributer )
[quoted text, click to view]
AddThis Social Bookmark Button