CDS Data Migrator

This XrmToolBox tool allows you to export data from one Microsoft Dataverse environment and import it into another (developed by Capgemini).

In most of the Dynamics 365/Power Apps systems, the configuration data stored in the tables and cannot be transferred using the solution package.

To move configuration data across environments, you can use this tool to create schema, export data from one environment using a schema file and import it to another environment.

This tool is the advanced version of the Configuration Migration tool by Microsoft and you can find out the full list of feature comparison here. The highlights are

1. Colour coded list of columns
2. Lookup mapping in export/import
3. GUID mapping in import
4. Filter export data
5. Migrate Calendars
6. Data obfuscation (coming soon).

• Tool Information
• Documentation
• Intro Video
• Functionalities
• Generate/Modify Export Schema File (Fig. 1)
• Generate/Modify Export Config File (Fig. 2)
• Specify the different column to lookup instead of GUID (Fig. 2, Pt. 1)
• Filter the data to be exported using the FetchXML filter (Fig. 2, Pt. 2)
• Generate/Modify Import Config File (Fig. 3, Pt. 1)
• Specify the GUID mapping to replace during the transformation of the data to be imported (Fig. 3, Pt. 1)
• Import Data (Fig. 4, Pt. 1)
• Export Data (Fig. 5, Pt. 1)
• Additionally, the tool can
• Show the column types in colour coded (not creatable/updatable, out-of-the-box, custom, GUID and primary name column) (Fig. 1, Pt. 1)
• Similar Tool
• _n.EnvironmentComparer
• Configuration Migration
• CRM Simple Record Cloner
• Data Migration Tool
• Data Transporter

Fig. 1 - Generate/Modify Export Schema File

Fig. 2 - Generate/Modify Export Config File

Fig. 3 - Generate/Modify Import Config File

Fig. 4 - Export Data

Fig. 5 - Import Data

This is part of the #TooLDR series where I test and review the tools for Power Platform. You can check out the information for the other tools on this page.