How do you transfer the data from a CRM 4.0 database into another CRM 4.0 database?

Question

Our client wants to transfer all the data in the Production CRM 4.0 database and use it in UAT. What is the best way to transfer the data over.

Answer 1

I would copy the database. Then use the Deployment Manager tool to import the organization (this will update the MSCRM_CONFIG database, etc.). You may have to be careful with things like running workflows - as last I recall these might save stuff like Organization Name in their serialized state.

Answer 2

Another option is to use scribe. this is considered the industry standard tool for moving CRM data around.

http://www.scribesoft.com/