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!
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?
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.
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
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? 🤔
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!
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
stampcoin
17
mmbr1606
15
Super User 2025 Season 1
ankit_singhal
11
Super User 2025 Season 1