Microsoft Dynamics 365 | Integration, Dataverse...

Export Dataverse table schema from one tenant and import into another tenant

(3) Share

Report

Posted on by SAGOS_12

Hi,

I wanted to check if this approach is feasible.

It will take a couple more weeks for me to gain access to a banking client’s development environment. In the meantime, I already have the requirements and design ready. To utilize this time effectively, can I create the tables (there are over 70) in my work tenant and once I have access to the client laptop and their development environment, would it be possible to export all the tables (schema not data) into the client environment? This way, I can avoid duplicating my efforts in creating tables, relationships again.

Thank you.

Categories:

Dynamics 365 general

Power Platform integration

I have the same question (0)

All responses (3)

Answers (0)

Sort by

Suggested answer

PerezAguiar Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hey.

first question is: will all your your tables be Custom? You have 2 possibilities:

- For a quick deployment, you can generate a solution on your current device with your 70 tables, as a managed solution. Then import on your new device (also as managed). ANy additional customization will have to be an extra solution that will have a requirement on this initial solution.

- You can also use Configuration Migration Tool as indicated on https://learn.microsoft.com/en-us/power-platform/admin/manage-configuration-data

Regards,

Was this reply helpful? Yes No
SAGOS_12 10 on at

Like (0)

Report
Copy link

Link copied!

Hi @PerezAguiar

Thank you for responding. All the tables are custom.

1. Since it is banking client, i cant do solution import and export.

2. I need to check the tool, if it is csv or excel, i can get permission to transfer that into client machine and import the table schema, if it is whole .zip file, i am afraid the bank folks wont agree to it.

I am looking for some solution like - we can get table schema in json right with this https://organization.crm3.dynamics.com/api/data/v9.2/EntityDefinitions, is it possible to use that json and may be a https post with power automate to create tables ??

Was this reply helpful? Yes No
Suggested answer

PerezAguiar Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hey

For simple datatypes, probably you can export the JSON File for each table, then generate an excel sheet using the JSON File, and then tell dataverse to generate tables based on an excel sheet.

However, for more complex tables with relationships, I wouldn't be sure of this approach.

The Configuration Migration tool usually generates a zip file that contains the schema of the object and another xml with the data (that uses the schema as a model).

Regards,

Was this reply helpful? Yes No