Unanswered

Export table schema without exporting Solution to another Environment

(0) Share

Report

Posted on by CU26080721-1

Hi ,
I was looking for a way to export the table schema (in DEV environment) and import into the same table (in PROD environment).

In PROD I have a table and in DEV I have the same table but with 2 new fields.
Now, I wanna import this table in PROD without losing old data.

I don't want to export "all the solution".
Is there a way to import only "the table schema" of the same table in other environments?
In other words: a way to UPDATE the table schema that doesn't involve the solution deploy

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (3)

Answers (0)

Shashank Bhide 942 Moderator on at

Like (1)

Report

3 ways.

1. Create a new solution in your dev environment, include only the table you need, export it as managed, import it in the target environment.

2. If you don't want to create a new solution, then create a patch of the existing solution where your table is residing, and only include the table you need, the export the patch and import it in target.

3. you can do a full solution import of the solution where your table resides and at the time of import, choose "upgrade" solution which is also the default option.

Was this reply helpful? Yes No
Devvj 1,132 Super User 2024 Season 1 on at

Like (1)

Report

Hi @Pepp1995
No data will be lost if you import a updated table to a new environment, you can even create a solution to just include the 2 fields that are new if that feels better.

Just add an existing table in to your solution

Then choose "Select object" and just add the new fields that you want to export

Then its just to import the solution into the other environment.

Was this reply helpful? Yes No
opticshrew 193 on at

Like (0)

Report

Possibly something in XRM toolkit also.

Was this reply helpful? Yes No