locked
Ad hoc test and training environments with a subset of data from production RRS feed

  • Question

  • We need to be able to create new ad hoc test and training environments with a subset of data from production.

    Under normal circumstances, I would restore a SQL database and import the restored database as a new organization in MSCRM. However, the production database is roughly 500GB and the system job therefore requires quite some resources and storage. This we do not have available for other than the “normal” development/test/training environments.

    I was thinking of C#-ing myself around the issue, taken only a subset of production data. This is an easy way to control the quantity and what data, though, there are many entities, and of cause, all are bundled together into one big mess.

    Are there any best practices concerning this issue? All environments are on-prem.

    Friday, February 6, 2015 8:44 PM