sql server replication: I need to be able to script out replication from servers
remotely. I would like to be able to script directly to
files so I can use osql to run the scripts to recreate
replication when I am finished.

Requirements:
1. Make create scripts for all publications including all
articles and filters.
2. Create all pull and push subscription.
3. Create the drop scripts in order by server.
4. Be able to run this from one server with linked or
remote server enteries for every server.

Known elemets:
1. All servers that have replicaiton.
2. Connection properties.
3. Utility script used to run remote commands on all
servers.
4. Plenty of disk space for scripts on central
administration server.

Unknown factors:
1. Name of each publication.
2. Name of each database on each server that is published.

Any help is appreciated.

Gary

I'm not sure if this is what you are looking for but you can script
replication from Enterprise Manager.

Rand
This posting is provided "as is" with no warranties and confers no rights.

I am trying to avoid having to use it. I do not want to
have to spend that time.

Gary
[quoted text, click to view]