Post reply

Copying a replicated environment to another instance

  • June 15, 2014 at 9:43 pm

    #292353

    Hello,

    As the subject suggests - I have a situation with two databases set up on one instance os SQL 2008R2. One of the databases is treated as a head-office (HO) database, and the other as a branch (BR) database.

    A transactional publication is also set up on that same SQL instance to publish a number of objects from HO to BR

    Then there is a local subscription set up for the BR database that accepts the replicated information.

    The question is "how can I replicate this environment (including publications and subscriptions) to another SQL instance on another server in order to set up a test environment ??"

    Thanks in advance!

  • June 17, 2014 at 3:54 am

    #1722208

    This can be done by taking a synchronous backups in production and restore them to development.

    Here are some links that will guide you,

    http://blogs.msdn.com/b/repltalk/archive/2010/03/16/deep-dive-on-initialize-from-backup-for-transactional-replication.aspx

    http://msdn.microsoft.com/en-us/library/ms147834.aspx

  • June 17, 2014 at 5:06 am

    #1722247

    You can generate script of the existing replication and execute it on your test environment. If required you can change the database name.

    ---------------------------------------------------
    "Thare are only 10 types of people in the world:
    Those who understand binary, and those who don't."

  • June 17, 2014 at 3:57 pm

    #1722534

    Thanks to all for the replies - they all worked a treat 🙂

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

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