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.
Congratulations to our 2026 Super Stars!
We are thrilled to have these Champions in our Community!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Giorgio Bonacorsi 738
André Arnaud de Cal... 453 Super User 2026 Season 1
Syed Haris Shah 286 Super User 2026 Season 1
