Seamless Transition to Business Central Online: High-Quality Migration for Multitenant Solution
Leer másWhy 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:
- Business Central Service Tier(s)
- SQL Server database
Most non-SaaS deployments are often split into three configurations:
- Fully on-premises
- Azure VM hosted (Service Tiers) & tenanted SQL database (PaaS)
- Azure VM hosted (Service Tiers & SQL Server)
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:
- Install SQL Server on-premises
- Install SQL Server on an Azure VM
- Use Azure SQL Database (PaaS)
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”:
- Azure SQL Database is a high-availability database.
- Azure SQL Database is a scalable and intelligent service that includes features such as high-availability, backups, automatic index tuning, security vulnerability assessment, and advanced threat detection. When choosing a pricing tier for running your production database, make sure that you compare this to a similar setup for SQL Server on a virtual machine (including the cost of administration and maintenance).
- The performance of an Azure SQL database is correlated to the price you pay for usage, and new pricing models evolve over time. Use the scalability options within the service to change the database performance tier for your installation as your workload changes over time.
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.
Con 20 años de experiencia práctica en ERP/IT adquirida trabajando para una empresa de fabricación/distribución de suplementos para la salud y con proveedores líderes como Oracle y Microsoft, Andy se especializa en los aspectos técnicos de las soluciones Dynamics ERP y CRM, junto con una profunda experiencia comercial y de gestión de cuentas en el canal Dynamics que abarca más de 10 años.
Más información sobre Business Central
Five Strategies to Boost Profit Margins Selling Microsoft Dynamics 365 Business Central
Being a Microsoft Dynamics 365 Business Central Partner isn't easy. Navigating profits margins is a complicated puzzle.
Leer másQué Necesitas Saber Sobre el Examen MB-820: Guía para Desarrolladores de Business Central
En esta entrada del blog, aprenderás qué esperar del examen, cómo estudiarlo y cómo aprobarlo con éxito.
Leer másGuide to MB-820 success with the Developer Learning Journey Track!
Unlock your potential as a Dynamics 365 Business Central developer with our targeted readiness path, designed to guide you to ...
Leer másUnlock the Power of Empowered: A Comprehensive Booklet
Discover everything you need to know about Empowered, from its offerings to the community and commitment it brings.
Leer más