The Proper way to Refresh Live Data back into Test/Development Environments RRS feed

  • General discussion

  • I'm floating this out as a topic of discussion because I'm be curious to hear what others currently do. I'd like to mangage our CRM installations so that Production data periodically refreshes backwards into Test and Development environments. At first glance it seems like some combination of dropping the Org database in TEST/DEV and moving over the Production database could work, but I'm not sure as to the state of the Config database and if I need to touch deployment manager in order for that to work correctly.

    Also, how would one automate this, a powershell script? Or perhaps a something made in BIDS? I'm not really sure where to begin on this yet.

    Tuesday, April 19, 2011 2:35 PM

All replies

  • The proper way to do this in 4.0 was:

    1. In deployment manager, diasable the test/dev organization
    2. Delete the test/dev org.
    3. In SQL, drop the database for the test/dev org
    4. Restore the prod database to the test/dev SQL server
    5. In deployment manaager, import the the restored database as a new Test/Dev org.

    I'm about to do this for my CRM2011 install.  I'll post back on how it went...



    Tuesday, May 17, 2011 4:55 PM