Scripting Replication

Aug 22, 2007 at 9:28 AM
Hi

I'd like to start by thanking you for an excellent Tool!
I've been using something written in VBS to access the DMO but your Tool is much neater ;)

Is it possible to script out the replication aspects as well?
Specifically the Publications and their Articles.

I could never get them out in my VB Scripts.

Thanks

OutOfSpace
Coordinator
Aug 22, 2007 at 2:18 PM
Ooh.... server objects (as opposed to database objects).

Yikes! I've never really played much with replication myself.

I had a quick look and SMO appears to support the Script method upon a ReplicationServer object... but it's got it's own Scripting options and I'm not too familiar with them yet.
Let me have a look and see what I can make of it.

Any particular layout requested?
Aug 23, 2007 at 9:16 AM
I not to fussed about layout.

A file for each publication would be excellent but a single file for everything is useful to :)

I'd gladly help with any testing.
Sep 27, 2007 at 2:55 AM
I add my vote for replication scripting.