dbTalk Databases Forums  

Scripting Client Distribution Subscriptions

microsoft.public.sqlserver.replication microsoft.public.sqlserver.replication


Discuss Scripting Client Distribution Subscriptions in the microsoft.public.sqlserver.replication forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Will Gillen
 
Posts: n/a

Default Scripting Client Distribution Subscriptions - 11-03-2004 , 10:01 AM






I have the following scenario:

One SQL Server 2000 as publisher and distributor with one merge publication,
one transactional publication, and one snapshot publication.

Two Client laptops with MSDE 2000 (SP3) which will be "intermittently"
connected to the network.

The two clients will subscribe to the Publications with the distribution
agents running every 10 minutes to check for updates.

I want to generate SQL script for adding the subscriptions to the clients.
I have "manually" created the subscriptions on a development laptop.
However, when I "geneerate SQL Script" for the subscriptions, I notice that
the Script has the client machine name "hardcoded" in the script. And also,
the script "names" the Agents with some long generated strings.

I am wanting to create a "generic" install script that I can run on all the
production laptops to setup the subscriptions/agents.

Any help in way of examples or good resources for how to accomplish this
would be much appreciated.

Thanks.

-- Will G.



Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2013, Jelsoft Enterprises Ltd.