Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Applies to: 
Azure SQL Database
Azure SQL Managed Instance
SQL Server on Azure VM
The Azure portal includes a decision tree in the Azure SQL hub at aka.ms/azuresqlhub to help you Find the right option for your application architecture in Azure SQL.
Decision tree diagram
The following decision tree diagram shows each high-level decision step.
Decision tree explained
The following explanation covers each high-level decision point. Your application architecture might involve other factors and decision points.
Are you building a new application?
Yes: Consider Azure SQL Database and Azure SQL Database Hyperscale.
If you're building a new SaaS (Software-as-a-Service) solution for hundreds of customers or more, consider Azure SQL Database, using elastic pools to provide cost-effective and predictable resource costs to many distinct customer databases.
If you're building other types of applications, consider Azure SQL Database Hyperscale. You could also consider Azure SQL Database Hyperscale elastic pools to provide cost-effective and predictable resource costs to many databases.
No: The best platform choice depends on other factors, like whether you're migrating an existing workload and other features. Keep reading.
Are you migrating an existing database?
No: Consider your migration and application goals.
If you want to manage your existing SQL Server instance from Azure without migrating it, use SQL Server enabled by Azure Arc. Connect your on-premises or multicloud SQL Server instances to Azure for centralized management, migration assessments, and security insights.
If you're building a new SaaS (Software-as-a-Service) solution for hundreds of customers or more, consider Azure SQL Database, using elastic pools to provide cost-effective and predictable resource costs to many distinct customer databases.
If you're building other types of applications, consider Azure SQL Database Hyperscale. You could also consider Azure SQL Database Hyperscale elastic pools to provide cost-effective and predictable resource costs to many databases.
Yes: Consider your existing infrastructure and desired requirements.
If you want to connect your SQL Server to Azure for guided migration recommendations, use SQL Server enabled by Azure Arc. Connect your on-premises or multicloud SQL Server instances to Azure for centralized management, migration assessments, and security insights.
Otherwise, keep reading.
Do you need operating system-level control, file system access, or a specific SQL Server version?
Yes: SQL Server on Azure Virtual Machines is the best solution for on-premises migrations that require operating system-level and file system access, perhaps for integration with other applications that must be installed locally to the SQL Server instance. You can migrate or extend an on-premises SQL Server workload to the cloud while keeping full control over the environment and configuration.
If you must run a specific version of SQL Server that isn't the latest version and won't be automatically kept up to date, use SQL Server on Azure Virtual Machines.
No: Consider what feature requirements you have from the existing database platform. A platform as a service (PaaS) database that manages the SQL Server instance and operating system patching for you is easier and simpler to operate. Keep reading for more options.
Does your workload require transactional replication, .NET CLR, SQL Agent, cross-database queries, or linked server?
Yes: Choose Azure SQL Managed Instance. These SQL Server and Windows features are available with Azure SQL Managed Instance, even as other aspects of the instance and operating system are managed for you, such as patching, high availability, and backups.
No: If you don't need those features, other Azure SQL options are available that simplify your database administration. Keep reading.
Do you need, or does company policy require, the ability to move the database back to on-premises or cross-cloud?
Yes: Choose Azure SQL Managed Instance, which provides migration and reverse migration, as well as on-prem-to-cloud synchronization through availability groups.
No: Other options remain available for your scenario. Keep reading.
Do you expect the database to stay under 4 TB?
Yes: Choose Azure SQL Database. Further, if you're considering a new SaaS (software-as-a-service) solution for hundreds of customers or more, configure Azure SQL Database with elastic pools to provide cost-effective and predictable resource costs to many distinct customer databases. You could consider a database architecture that separates each customer into its own database using elastic pools, each expected to stay under 4 TB.
No: Azure SQL Managed Instance and Azure SQL Database Hyperscale provide much higher total database size limitations. Keep reading.
Do you expect your database to stay under 32 TB?
Both Azure SQL Managed Instance and Azure SQL Database Hyperscale could work for your solution, but Azure SQL Managed Instance has a current cap of 32 TB. Azure SQL Database Hyperscale has a current cap of 128 TB.
- If you're building a new SaaS (software-as-a-service) solution for hundreds of customers or more, consider Azure SQL Database Hyperscale elastic pools or Azure SQL Managed Instance pools to provide cost-effective and predictable resource costs to many distinct customer databases.