Manage your configuration data


Applies To: Dynamics CRM 2013

The Configuration Migration tool is a new tool for Microsoft Dynamics CRM Online Spring ‘14 and Microsoft Dynamics CRM 2013 Service Pack 1 (SP1) (on-premises) that enables you to move configuration data across Microsoft Dynamics CRM instances and organizations. Configuration data is used to define custom functionality in Microsoft Dynamics CRM, and is typically stored in custom entities. Configuration data is different from the end user data (account, contacts, and so on). A typical example of configuration data is what you define in Unified Service Desk for Microsoft Dynamics CRM to configure a customized call center agent application. The Unified Service Desk entities, along with the configuration data that is stored in the entities, define an agent application. For more information about Unified Service Desk, see Administration Guide for Unified Service Desk for Microsoft Dynamics CRM.

The Configuration Migration tool enables you to:

  • Select the entities and fields from where you want to export the configuration data.

  • Avoid duplicate records on the target system by defining a uniqueness condition for each entity based on a combination of fields in the entity, which is used to compare against the values on the target system. If there are no matching values, a unique record is created on the target system. If a matching record is found, the record is updated on the target system.


    If no duplicate detection (uniqueness) condition is specified for an entity that is being exported, the tool uses the primary field name of the entity to compare against the existing data on the target system.

  • Disable plug-ins before exporting data and then re-enable them on the target system after the import is complete for all the entities or selected entities.

  • Validate the schema for the selected entities to be exported to ensure that all the required data/information is present.

  • Reuse an existing schema to export data from a source system.

  • Embed the exported modules created from this tool (schema and data files) in other programs. For example, you can use the exported data in Microsoft Dynamics CRM Package Deployer along with other solutions files and data to create and deploy packages on a CRM instance. More information: Deploy packages using CRM Package Deployer and Windows PowerShell


The Configuration Migration tool does not support filtering of records in an entity. By default, all the records in the selected entity will be exported.

The following diagram illustrates how the Configuration Migration tool is used for migrating configuration data.

Configuration migration process flow diagram

Icon for step 1 Define the schema of the source data to be exported: The schema file (.xml) contains information about the data that you want to export such as the entities, attributes, relationships, definition of uniqueness of the data, and whether the plugins should be disabled before exporting the data. More information: Create a schema to export configuration data

Icon for step 2 Use the schema to export data: Use the schema file to export the data into a .zip file that contains the data and the schema of the exported data. More information: Create a schema to export configuration data

Icon for Step 3 Import the exported data: Use the exported data (.zip file) to import into the target CRM instance. The data import is done in multiple passes to first import the foundation data while queuing up the dependent data, and then import the dependent data in the subsequent passes to handle any data dependencies or linkages. This ensures clean data import. More information: Import configuration data

The Configuration Migration tool provides logging support to get detailed information about errors that can occur while signing in to the CRM instance using the tool, activities performed by the tool during the schema definition and export/import of the configuration data, and information about the data that was imported using the tool. There are three log files generated by the tool that are available at the following location on the computer where you run the tool: c:\Users\<UserName>\AppData\Roaming\Microsoft\DataMigrationUtility\<Version>.

  • Login_ErrorLog.log: Provides information about the issues that occurred when you use the tool to sign in to the CRM instance. If there are any issues during sign in, a message appears on tool’s login screen with a link to this log file. The message states that an error occurred while processing the login request and the user can view the error log. You can click the link in the message to view this log file. The log file is created the first time you encounter any sign-in issues in the tool. Thereafter, the log file is used to log information about a sign-in issue, whenever it occurs.

  • DataMigrationUtility.log: Provides detailed information about each task performed in the tool during last run. You can view the log file from the tool by clicking the Logs menu on the main screen, and clicking Running Log.

  • ImportDataDetail.log: Provides detailed information about the data imported in the last import job by using the tool. Each time you run an import job using this tool, the existing details from the log file are moved to a file called ImportDataDetail._old.log in the same directory, and the ImportDataDetail.log file displays information about the latest import job run using the tool. You can view this log file from the tool by clicking the Logs menu on the main screen, and then clicking Last Import Log.

The following are things you should consider while using this tool to migrate your configuration data:

  • While creating the export data schema, you must define uniqueness rules appropriately for each entity to avoid any unintentional data updates on the target system.

  • Import the exported data in a pre-production environment (preferably a mirror image of the production environment) to ensure that the data import results are as you intended.

  • Back up your production environment before importing the data.

© 2016 Microsoft Corporation. All rights reserved. Copyright