How to back up Dataverse tables in production environment and is that even wise?

(0) Share

Report

Posted on by futr_vision

831 Moderator

Ok. Here is my scenario. I did some deleting of connections and flows in my dev environment and now I can't deploy to production. I am thinking that fastest route to a solution is to nuke my production solution and re-deploy my working development solution to production. The problem is I am unsure of what happens to my Dataverse tables. I think they get nuked if I nuke the solution in production. What is the best way to backup production tables? Do I export them one-by-one? I was looking for a way to export all of them at once but I don't see an option. I don't even see an option to export the entire solution.

Second question. If I export these tables, one of them uses autogenerated IDs, will they still work the same when I reimport them? Again, I am assuming nuking the solution is the answer to get this project moving forward.

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (4)

Answers (0)

Suggested answer

Gabriel G. 831 Super User 2025 Season 2 on at

Like (0)

Report

Hi,

You want to destroy your production environment cause some connection references has been dropped ? It seems a bit exaggerate :). What about you simply redeploy connections and then adjust it, if needed, in production environment ? Changing account inside a connection reference is not a big deal in a managed environment. Anyway, it should ask you to replace your account in connection reference on importation. If you have deleted flows, there's no problem since you don't have dependencies from flows (but you have dependencies from tables on your flow...) Same thing, you get back or redevelop flows if needed and redeploy them in Production environment.

Also, you can simply use an environment restore, but watch out! ONLY and only if you don't have any further solution since restore feature is 100% error proof.

Otherwise, I'm not sure it is quite safe to get out Production data... If your Production environment does not contains much sensitive data, you can try to duplicate your environment with data using the feature inside admin.powerplatform.com. Then, you migrate data from new environment to new production :/.

Here is the Microsoft documentation on how-to migrate data from an environment to another: https://learn.microsoft.com/en-us/power-apps/developer/data-platform/dataverse-odata-dataflows-migration

I hope it helps!
_________________________________________________

Please click Does this answer your question if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it a Like.

Was this reply helpful? Yes No
futr_vision 831 Moderator on at

Like (0)

Report

I'd love to restore the connections, but they have been deleted. This is the error message I get when I try to deploy from development.

The connectionreference(613ba08a-c326-4d8b-9e1d-460e5aa29284) component cannot be deleted because it is referenced by 2 other components. For a list of referenced components, use the RetrieveDependenciesForDeleteRequest.

I haven't been able to find those connection references and thus haven't been able to fix them. Any thoughts here? I could potentially roll back my development environment to the last time it deployed correctly. Maybe?

Was this reply helpful? Yes No
Gabriel G. 831 Super User 2025 Season 2 on at

Like (0)

Report

Well, you still can restore the environment, but it is not 100% error proof, so it is kind of dangerous.

Not sure how

many solutions layers you have and you can remove, but I definitely start by trying to get rid of the corrupted component before a restore on a production environment.

If you deployed a solution in the past, you can simply redeploy a new version of that solution without the elements to make an update and not an upgrade.

Was this reply helpful? Yes No
futr_vision 831 Moderator on at

Like (0)

Report

@GabGadou

Already restored the environment but I would like to know more about update vs upgrade. I don't recall seeing that option

Was this reply helpful? Yes No