Moving live CRM 4 db to Development server
When doing CRM development its sometimes important to take a copy of the LIVE CRM database and deploy it on your CRM Development server.
The steps below cover this scenario, presuming you already have CRM on your Development server:
- Use SQL Management Studio to restore the database to your development server; make usre you restore it to a different name than the one already deployed to DEV (as part of the install)
- Remove the Users and corresponding schemas from the restored database
- Run the CRM Deployment Manager to do an import; then follow the rest of the steps in Microsofts guid here:
The undocumented step 2 above cost me a few hours teh first time I went through this process; see this article: