Notifications
Announcements
No record found.
Dear Experts,
As azure being expensive, we would like to move data from D365 to On prem sql?
Please can advise, available options?
Yes, Dynamics 365 Finance and Operations supports on-premises deployment.
Please refer to the whitepaper - docs.microsoft.com/.../on-premises-deployment-landing-page
Hello YOG,
If I get you right, you have a cloud hosted D365FO deployment and you would want to get the cloud database to SQL database hosted on-premises.
Kindly explain better.
Hi Komi,
Yes, you're understanding is correct. We have D365FO hosted in cloud and currently using Azure SQL as byod. However want to move from Azure SQL to on prem SQL
Hi YOG,
You would have to take the backup of the database from a LCS which comes a .bacpac file and restore on Sql studio using a powershell command. Here is the sequence.
blog.monsieurwinner.com/.../
The export to BYOD is only supporting Azure SQL. If you need the data on-premise, you need to have a second tool to bring the data from Azure SQL to your on-prem SQL database.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Martin Dráb 551 Most Valuable Professional
André Arnaud de Cal... 450 Super User 2025 Season 2
BillurSamdancioglu 278 Most Valuable Professional
