Post reply

Setting up replication through script

  • August 29, 2005 at 12:36 pm

    #94712

    Hi ,

    I have several development projecta going on and we need to setup transactional replication almost daily.

    Does anyone have any script which can create transactional replication with pull and push subscription. The script should be parametrised so that we can input database names, artcles etc as required.

    Please help.

     

  • August 30, 2005 at 8:33 am

    #586156

    There are so many variables with replication, I don't think a generic script would help much.  How about scripting one of your existing publications and scripting an existing subscription, and using those as templates for a stored procedure and pass in parameteres.  I haven't tried it, but that would be a place to start.

Viewing 2 posts - 1 through 1 (of 1 total)

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