In this blog I will let you know about the importance of DEV environment for Microsoft Dynamics CRM and How you will create it by using PROD database.

Importance of DEV environment of Microsoft Dynamics CRM 

You will need Development environment in many scenarios such as:

  • Creating a new Solution for your CRM
  • Developing new customizations
  • Testing the imported solutions

By having DEV environment you will get your Live environment safe by testing the effects of newly imported solutions or customized items on DEV environment. After checking the effects you can safely moves the solution form DEV to PRD.

Creating DEV Environment:

Note: Whenever you create or import the solutions, be sure that Microsoft Dynamics CRM uses the same advocated frameworks and architecture that majority Microsoft developers consider. You have to create your development environment and apply the tools as per your organization’s business process. So it will make ease of work without having any difficulties.

To build a DEV Environment first of all you need a separate machine having the same version of Microsoft Dynamics CRM and SQL  server as PRD environment has.

After Installation, Create a backup or copy of the PRD’s database. Following are the Screen shots, that will help you out:

1. Go to SQL server management studio select the required database, Right click on it then click Tasks, then click Back up.



2. In Backup Type Select Full.



3. Now copy the .bak file to the DEV SQL server machine.

Open SQL Server management Studio in the DEV environment and Create new Database and select restore by doing right click on it.



4.  Put the desired name of new database & select earlier saved .bak file and click OK.



5. In Dev Environment open CRM Deployment Manager -> Import Organization Wizard.

6. Select SQL server and database that has been restored earlier (TEST2_MSCRM) and click Next.



7. Enter a desired Display name & click Next.



8. Fill Report Server URL column and click Next.



9. Mark Automatically Map Users as the Users of the PRD environment are present in the Active Directory of DEV Environment and click Next.

If Users of the PRD Environment’s Active Directory are not present in DEV Environment then you can also add them manually for that you have to select custom mapping options too.



10. Click Import and then Finish in order to complete the restoration process of the database into the DEV Environment.


Now Browse it by going to Deployment Manager of the DEV Environment and Start Customizing and Testing the Solutions.

Note: By doing above activity only Data & Customization of the PRD Environment will be imported successfully while Configuring the SharePoint, Email Router, etc.. will performed manually as it have been done in PRD.

I hope this blog will help you out in creating your DEV environment. For more upcoming and exciting blogs stay tuned to






Leave a Reply

Recent Comments