Copy table from one env to another

(0) Share

Report

Posted on by VBuki

Hi,

we have an app in prod. The app works with a lot of tables we have.

When we created a sandbox/dev environment and copied the app to the new environment, all the tables are missing.

I was trying to export a table from production and import it to the dev env. It works but the schema name is not the same as original. For example the column name in production is ddr33_name but in the new environment it is 4rgcc_ddr33_name.

Is it possible to just get a identical copy of a table in another environment?

I was also looking into solutions, would this be the right approach?

Thank you in advance!

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (6)

Answers (2)

Verified answer

365-Assist 2,324 Moderator on at

Like (1)

Report

Yes you can only do this using an Unamanged Solution. Her is some Documentation that explains how to use Soltuons. Solution concepts - Power Platform | Microsoft Learn

--------------------------------------------------
Please Accept as Solution if it solves your question. Or just give it a Thumbs Up if it is helpful as can help others.
Subscribe: https://www.youtube.com/channel/UCFpvUlpx84FuIPOdInGKMTw
Twitter: https://twitter.com/assist_365
Regards
Darren Lutchner - 365 Assist

Was this reply helpful? Yes No
VBuki 26 on at

Like (0)

Report

Thank you! And just to make sure, with the Solution I am creating a copy and don't move actually something from one environment to another?
I found this link > Power Apps Guide - Dataverse - how to access tables from another environment - Power Apps Guide - Blog

But it is not clear when switching from one environment to another and getting tables, are we copying them or we just use the same table just in different environments?

Thank you again for your fast reply, I really appreciate it!

Was this reply helpful? Yes No
VBuki 26 on at

Like (0)

Report

Ok so I created an unmanaged solution with all the tables needed. I have all the tables in the new environment but the tables are all empty. What did I do wrong? 🤔

Was this reply helpful? Yes No
Verified answer

365-Assist 2,324 Moderator on at

Like (0)

Report

You did nothing wrong. The data does not come across with solutions.
If you want to migrate the data you will need to export the table data to xls/csv and import them into the new environment one table at a time.
--------------------------------------------------
Please Accept as Solution if it solves your question. Or just give it a Thumbs Up if it is helpful as can help others.
Subscribe: https://www.youtube.com/channel/UCFpvUlpx84FuIPOdInGKMTw
Twitter: https://twitter.com/assist_365
Regards
Darren Lutchner - 365 Assist

Was this reply helpful? Yes No
mcsd 2 on at

Like (0)

Report

I recommend using a DataFlow to copy your table data from one environment to another. You can then set up the Dataflow to copy the data on a schedule or on a manual refresh.

Was this reply helpful? Yes No
Stas_Magid 2 on at

Like (0)

Report

Hi,

But if I export a table and import it to a new environment, won't it be assigned a new prefix to its name (according to the default environment publisher) so the migrated app will not recognize this table?

Was this reply helpful? Yes No