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.
-- Will G.