CRM 4.0 Loading Live Environment Data to Test/Dev

This is most questions or scenario we encounter I had encounter while working CRM and that is we want to load Live Environment Data to Test/UAT or Development environment.

I decided to give it go and following are detailed step to achieve this in CRM 4.0.

STEP 1: Back up existing Live Database

STEP 2: Restore this database on Dev/Test Database Server. Let’s assume our development database server name SQLDEV and we restored this database with name SQLDEV_MSCRM. It is important to have last string in database name as _MSCRM.

STEP 3: Log in to CRM Deployment Manager

STEP 4: Click on Organizations and then click Import Organization (right hand side)

STEP 5: then select the source SQL Server and source database (as shown in figure below) and click Next

STEP 6: then select the report Server name and generally it would be database server so in out case it would be http://SQLDEV/reportserver and then click Next

STEP 7: Now select the mapping of user as per your requirement, you create mapping file and use that for user mapping. For this example we will keep it simple and just use to auto map users using AD account name and click Next.

STEP 8: System will show you entire list of mapped user and allow you edit user mapping as well. Then we can click next and if any of users does not mapped then system will give warning for the same. Ignore warning and click yes because we can map this manually later on…

STEP 9: System check all system requirements for SQL Server and Reporting Services and then click next
STEP 10: the system will show you Ready to install screen with all summary of new CRM Organisation. Click Import button. System will then create new dev environment with live data.
STEP 11: Done, You will see the success screen and if there is any problem you can check installed log file and the correct problem and start again.
STEP 12: Log on to new environment using URL
http://ServerName:port/Organisation name/loader.aspx

1. You need to be Active directory administrator to be able to do this.
2. This will not do any extra add-ons or custom development which is not part of database so you will need to manually do this on new CRM Environment.


5 thoughts on “CRM 4.0 Loading Live Environment Data to Test/Dev


    Just a quick question. How did you install this instance of CRM in the first place? I installed it and it created a test dev as TESTDEVCRM_MSCRM or something but that’s the name I want to keep. If I import the new organisation as the same name what is going to happen?

    I just don’t get the import organization thing. Did you just not provide a database name when you installed or something.

    1. mayankp Post author

      you will not able to import organisation with same name …

      if you want to keep the same organization name then you need to delete existing organization and delete relevant report folder then you can import it..otherwise not..

  2. mayankp Post author

    Hi Vijay,
    as per Note 2 in above article, you will have do them separately again.

    Is there any custom web site you got in .Net? if yes then they need to separately put in to new test environment.


Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s