Microsoft Dynamics 365 | Integration, Dataverse...

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

(1) 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

All responses (3)

Answers (0)

Suggested answer

PerezAguiar on at

Like (0)

Report

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

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,
SAGOS_12 on at

Like (0)

Report

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

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 ??
Suggested answer

PerezAguiar on at

Like (0)

Report

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

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,

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

Helpful resources

Quick Links

Congratulations 2024 Spotlight Honorees

Meet the Top 10 leaders for December

Start Your Super User Journey Pt 2

Leaderboard

Featured topics

Product updates

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

Helpful resources

Quick Links

Congratulations 2024 Spotlight Honorees

Meet the Top 10 leaders for December

Start Your Super User Journey Pt 2

Subscribe to this forum!

Select categories

Leaderboard

Featured topics

Product updates