Answered

Refresh Test Dataverse Tables from Production Data

(0) Share

Report

Posted on by pwarago

Hi Everyone,

As a monthly activity, I refresh our DEV and TEST SQL databases with PROD data. So that testers and developers have access to the latest prod data. I use tools like Visual Studios SQL Server Data Compare tool to conduct this task easily. We now have DEV, TEST and PROD Dataverse and I want to do the same for our Datavese tables.

Are there any tools out there where I can easily update DEV and TEST Dataverse tables with PROD Dataverse data?

Thank you.

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

MarioRing 541 Super User 2024 Season 1 on at

Like (1)

Report

You can use Configuration Migration Tool provided by Microsoft. It allows you to create a reusable XML schema file where you choose all required entities and their fields (don't be confused by the title - it's not for configuration only) and export the data to .zip file, and then import it to another environment.

(image credit)

You can also use the XRMToolBox plugin Data Transporter by Bram Colpaert, where you can directly copy data between environments. It is especially useful for dictionaries-like data.

Was this reply helpful? Yes No
pwarago 12 on at

Like (1)

Report

Thank you @MarioRing !! Much appreciate your help.

Was this reply helpful? Yes No