Backup or migrate tables

(0) Share

Report

Posted on by AndKanPA

214

Hello community,

how can data copied to another tenant?

I used "Export data", downloaded a ZIP... and imported again.

Export/Import

I downloaded one ZIP file containing different CSV files.

Each CSV file has to be uploaded manually, wait until upload, next file. WF?

One other funny thing is: Empty date fields are imported as "1/1/1753" (minimum date). Why?

But that's an real issue and problem.

There is no date in CSV file, but after import in table.
Of course there is a difference between 'null' and a date ... 'Contains data' or 'Doesnt contains data'

Any ideas how to dump tables (like mysqldump) for import again?

Thanks for help,

AndKan.

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (5)

Answers (1)

Verified answer

JisungHan Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @AndKanPA ,

Here is the "Configuration Migration tool" that may help to migrate data from Environment A to B. This will work not only for Dynamics 365(CRM) but also Dataverse(CDS) Here are references regarding this tool:

Microsoft Dynamics 365 CRM Configuration Migration Tool

https://powerobjects.com/tips-and-tricks/microsoft-dynamics-365-crm-configuration-migration-tool/

Move configuration data across environments and organizations with the Configuration Migration tool

https://docs.microsoft.com/en-us/power-platform/admin/manage-configuration-data

Hope this helps. Thanks!

Best regards,

Jisung Han

Was this reply helpful? Yes No
AndKanPA 214 on at

Like (0)

Report
Copy link

Link copied!

Thank you @JisungHan ,

I'll try this way.

Was this reply helpful? Yes No
JisungHan Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @AndKanPA ,

Sure, this is migrating not only configuration and schema but also records. Please try and share the outcome with us.

Best regards,

Jisung Han

Was this reply helpful? Yes No
ChrisPiasecki 6,422 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi @AndKanPA,
The configuration migration tool is not meant for moving large amounts of data. It's purpose is for, as it's name implies, moving configuration data.
You could look at using Dataflows and the Odata connector to connect to the Dataverse Web API and move it to your environment in another tenant.
More information at the reference below.
https://docs.microsoft.com/en-us/powerapps/developer/common-data-service/cds-odata-dataflows-migration
---
Please click Accept as Solution if my post answered your question. This will help others find solutions to similar questions. If you like my post and/or find it helpful, please consider giving it a Thumbs Up.

Was this reply helpful? Yes No
AndKanPA 214 on at

Like (0)

Report
Copy link

Link copied!

Hello @JisungHan ,
this tools works as expected.
It needs 2 hours for 19.000 records, but equal for now.

Ty.

Was this reply helpful? Yes No