You’re offline. This is a read only version of the page.
80
Hi All
What is the best way to restore database from D365 F&O Production to development vm without transaction data?
As our PROD data is grown more than 400 gb, restoring in cloud hosted development VM's will consume more space. We only want to have setup and master data to be available in development box.
Regards
Pradeep
Yes, we need both setup and master data. Also we have 150 plus legal entities. Legal entities are getting onboarded as part of consolidation of erp. It looks we will need to spend good amount of time to prepare this. The other option I see is to load new legal entities on old gold backups. Thank you for your input.
Hi Pradeep,
Please check this post. You can restore Prod DB to your UAT (Sandbox) environment and delete the transaction data using the URL provided.
You can then export the data into a bacpac file and restore on your Dev environment. Before you do that, you may want to check the cleanup routines as well and see if you can reduce the DB size.
Hi Pradeep,
Do you want to keep setup only or also master data? I do assume also the master data as settings alone does not make that much sense for unit tests. There is no easy way to achieve this. You an or restore the full database and delete transactions with a script or copy data using data management tools for tables individually.
You might restore it in one machine; then delete transactions and then move this database to other development machines. You can try to use the class SysDatabaseTransDelete to delete the transactions. This class has been deprecated by Microsoft, but it is still available. This needs to be run per legal entity. There is a reason why Microsoft deprecated it, so check carefully what had been deleted or left behind.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,151
Super User 2024 Season 2
#2
Martin Dráb
229,963
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (