Post reply

Documenting replication

  • April 18, 2007 at 11:46 am

    #92341

    I just started a job where there is no documentation of any kind. I would like to know if there is a utility I can use to document sql server 2000 transactional replication.

    Thanks.

     

  • April 19, 2007 at 9:03 pm

    #701612

    Do you mean scripting publications?

  • April 26, 2007 at 1:42 am

    #702541

    Hi,

    You can get, I believe, software that will document your structure..not sure about replication.

    What I would do (and have done) is do your own. you can script the publications and that will give all the articles and subscribers. I then did a table of replication jobs and their schedules plus diagrams of how the data is moved and to which servers/databases. I would say this is pretty vital in the event you are not around.

    HTH Graeme

  • April 27, 2007 at 9:36 am

    #702978

    You can use MS Visio for the documentation. Its very easy to use and can be always used for storing and understanding replication structure. Here we can create a diagram with all publishing and subscribing servers and all the publishing articles .

  • April 30, 2007 at 10:56 am

    #703356

    Thanks for the help. I appreciate it.

    Jerry.

     

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply