Making sense of Azure and Azure Arc deployment options for SQL Server

For some years Microsoft Azure has been offering several different deployment and management choices for the SQL Server engine hosted on Azure. With the release of the Azure Arc support for SQL Server, the range of different options has grown even further. This article should help you make sense of the different choices and assist in your decision-making process.


The following diagram shows a high level map of the options available on Azure or via Azure Arc.  



As you can see, both on-Azure and off-Azure options offer you a choice between IaaS and PaaS. The