{"id":29853,"date":"2020-03-17T09:00:20","date_gmt":"2020-03-17T16:00:20","guid":{"rendered":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/?p=29853"},"modified":"2024-01-22T22:51:24","modified_gmt":"2024-01-23T06:51:24","slug":"tips-to-select-the-best-azure-sql-deployment-option","status":"publish","type":"post","link":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2020\/03\/17\/tips-to-select-the-best-azure-sql-deployment-option\/","title":{"rendered":"Tips to select the best Azure SQL deployment option"},"content":{"rendered":"

When it comes time to migrate your SQL workloads to Azure, you have a choice of two main deployment options: SQL Server on Azure Virtual Machines and Microsoft Azure SQL Database. Each offers its own benefits, so how do you know which is right for your workload? If you\u2019re ready to learn more about moving SQL Server to the cloud, read the e-book, Future-Proof Your Data Infrastructure with Azure: A Business Case for Database Administrators.<\/a><\/p>\n

Azure SQL deployment options differ primarily in their cost and the amount of control they give you over the underlying platform. You can use the option that best meets the requirements for each application you migrate to the cloud without increasing complexity. By providing a single, unified management experience, Azure SQL eliminates the complexity of managing diverse collections of SQL Server-based applications at scale.<\/p>\n

Azure SQL Database<\/h2>\n

Azure SQL Database is a general-purpose relational database, provided as a managed service. Categorized as a platform as a service (PaaS), Azure SQL Databases are built on standardized hardware and software that is owned, hosted, and maintained by Microsoft. When using Azure SQL Database, you pay-as-you-go, with the option to scale up or out with no service interruption.<\/p>\n

Within Azure SQL Database, you have the option to deploy a managed instance. Azure SQL Database Managed Instance is a collection of system and user databases with a shared set of resources. In addition to all the PaaS benefits of Azure SQL Database, this option provides a native virtual network (VNet) and near 100 percent compatibility with on-premises SQL Server. Azure SQL Database Managed Instance provides you with full SQL Server access and feature compatibility for migrating SQL Servers to Azure.<\/p>\n

Recommendation:<\/strong> Choose Azure SQL Database for your modern cloud applications, or when you have time constraints in development and marketing.<\/p>\n

SQL Server on Azure Virtual Machines<\/h2>\n

SQL Server on Azure Virtual Machines give you full administrative control over the SQL Server instance and underlying OS for migration to Azure. As an infrastructure as a service (IaaS) solution, SQL Server on Azure Virtual Machines run on standardized hardware that is owned, hosted, and maintained by Microsoft. You can either pay-as-you-go for a SQL Server license already included in a SQL Server image or use existing SQL Server and Windows Server licenses.<\/p>\n

Recommendation:<\/strong> Use SQL Server on Azure Virtual Machines when you\u2019re migrating applications that require OS-level access or you\u2019re moving applications that require a fast migration and minimal changes. SQL Server on Azure Virtual Machines is also ideal for rapid development and test scenarios when you don\u2019t want to invest in on-premises non-production SQL Server hardware.<\/p>\n

Final advice for choosing an Azure SQL deployment option<\/h2>\n

Still not sure which Azure SQL deployment option is right for you? Start with Azure SQL Database Managed Instance. Its built-in intelligence learns your application\u2019s patterns and adapts to maximize performance, reliability, and data protection.<\/p>\n

However, you may also benefit from using SQL Server on Azure Virtual Machines if you have one of the following scenarios:<\/p>\n