Blog |

Why is Azure SQL so important for Dynamics 365 Business Central?

Tuesday, September 8, 2020
Reading time: 7 minutes

Let us start with a common question:

“When a customer is not considering going with Business Central SaaS, what are the options to move to the cloud?”

Dynamics 365 Business Central has a clear advantage against competitor ERP solutions that do not offer and on-premises or hybrid solution. When we talk about deployment choices, we are really referring to two elements:

Most non-SaaS deployments are often split into three configurations:

More about common configurations

Each of these common configurations has its own advantages and disadvantages. There is clearly not a right or wrong configuration here. It is ultimately all down to what requirements customers have.

Whilst the three options above are the snapshot of a complete Business Central deployment, we need to pay particular attention to the database and where it is hosted!

When deciding on where the database should reside, the options are:

When you decide to adopt options 1 and 2, there is a high level of maintenance involved. This often falls entirely or partially with the Dynamics partner, certainly with many SMB customers deployments, where they do not have a dedicated IT department.

Option 3, on the other hand, offers the capabilities of SQL Server in a PaaS configuration. This means that the maintenance (patching, security, etc.) fall entirely on the service provider, in this case, Microsoft Operations.

Contrary to general belief, SQL Server (on-premises/Azure-hosted version) and Azure SQL, differ in design. The latter is specifically architected for cloud computing, performance, and scalability. Some additional features such as geo-replication and geo-redundancy, are only available with Azure SQL.

What’s the difference between Azure SQL and SQL Server?

When comparing the performance of Azure SQL database and a SQL Server deployed to a virtual machine, we need to consider a few intrinsic “differences”:

So why is it recommended for Business Central?

You can deploy a Business Central database to Azure SQL Database. Azure SQL Database is a cloud service that provides data storage as a part of the Azure Services Platform.

To optimize performance, Microsoft recommends that the Business Central Server instance that connects to the database is also deployed on a virtual machine in Azure. Additionally, the virtual machine and SQL Database must be in the same Azure region.

For development and maintenance work on Business Central applications. If the Dynamics NAV Development Environment is installed on the same virtual machine in Azure as the Business Central Server, then you can connect to the Azure SQL database from the development environment.

Does Companial offer any training for my technical resources on this specific topic?

Of course, we do! Our very own Jan Veenendaal, Partner Technical Strategist, has developed a unique “hands-on” workshop only available from Companial to educate our Partners about this topic. You can find the full details of the workshop on our Companial Academy page.

Andy De Rosa
More about Business Central
Isatech

How Isatech Moved Customers to Business Central Online 5 Times Faster with the Migration & Modernization Program​

Learn more