Copy Data from One environment to another

(1) Share

Report

Posted on by ay26274

Hi,

I have a requirement to copy data from the UAT to the PRODUCTION environment.
My Dataverse table has three columns: a unique identifier, a primary key, and a CreatedOn column.
I need to replicate these three columns’ data from UAT to PRODUCTION.
I have tried the import method, which allows me to copy the primary key and CreatedOn columns, but the unique identifier is not copied over, likely because it performs Create statements.
I have also tried the Dataflow method, which lets me copy the unique identifier and primary key columns, but the CreatedOn column is not available for editing.
I have used Data Transporter, Data Import ++, and many other plugins in the XRM toolbox, but I have not achieved the desired result.

Any help would be greatly appreciated.
Thanks in advance!

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (3)

Answers (0)

Shashank Bhide 942 Moderator on at

Like (0)

Report

https://rajeevpentyala.com/2017/11/18/set-created-on-created-by-modified-on-modified-by-fields-using-sdk-data-import-plug-in-dynamics-365/

"Set the “overriddencreatedon” field to the date, which you want your “Created On” date as."

Was this reply helpful? Yes No
Suggested answer

CU03091618-0 2 on at

Like (0)

Report

Hello,

There are two methods for copying along with the GUID

1. You can use the Configuration Migration Tool (CMT)

https://learn.microsoft.com/en-us/power-platform/alm/configure-and-deploy-tools
https://learn.microsoft.com/en-us/power-platform/admin/manage-configuration-data

If you have the CLI already installed then you can launch the tool by "pac tool cmt"
Microsoft Power Platform CLI

2. Importing file through CSV method

Convert the file to CSV and map the respective columns while importing (Unique ID - GUID also can be mapped)

Was this reply helpful? Yes No
Suggested answer

Fubar 8,361 Super User 2025 Season 2 on at

Like (0)

Report

I am assuming by Unique identifier you mean the guid of the record and Primary Key you actually meant the Primary Name column (if not please clarify what you mean by Unique identifier).

As already posted by others you should be able to move the data using the Configuration Migration Tool, this tool allows you to export, alter the import schema, and import data. As you are wanting to maintain the Created on date you will need to adjust the schema prior to import so that your source createdon goes in the overridencreatedon field there is also a setting to maintain the guids (if you want/need them to be same) so confirm that is also set appropriately.

You can also do similar using Dataverse's standard data import (e.g. from Advanced Settings->Data Management->Import), in which case you would need to update the field import mappings when you import the file, and set the GUID to go in the <the tablename > (Primary Key) column (e.g. if the using the Contact Table, "Contact (Primary Key)" from the list of fields), and make sure the createdon field is mapped (by default you may find it is not mapped or is set to Ignore). However, just be aware that if you have exported using export to excel you may need to save as CSV or XML 2003 to import.

Was this reply helpful? Yes No