Copy data from one server to another or copy design tables from server to another

  • Hello, Is anyone know any tools that you can copy one server to another. We have 3 servers: Production, Staging and development. I would like to copy their data from Production to Staging and from Production to Development. I have a store procedure that runs everyday and deletes data from tables and inserts data from Production to Staging and development. I am trying to find a better way to do it.

  • This has already been asked and answered here... http://www.sqlservercentral.com/Forums/Topic575393-65-1.aspx.

    Please don't multi post.

    -Luke.

    To help us help you read this[/url]For better help with performance problems please read this[/url]

  • yulichka (9/24/2008)


    Hello, Is anyone know any tools that you can copy one server to another

    Assuming this was a question... Yes, I do.

    _____________________________________
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at Amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

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

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