How to choose the target Azure SQL platform while migrating on-premise SQL Server database?

As part of database migration to cloud one of the important decision to make is which target platform to choose. As discussed in the previous article there are multiple options to choose from the Azure SQL family while migrating our on-premise SQL Server.  

Below flowchart helps in choosing the target Azure SQL platform from a database perspective by evaluating scenarios like if we want to migrate a single database or multiple databases, if want to use only database scoped features or we want to use instance scoped features as well, if we have any other applications that we need to migrate along with the databases, if we want the control of underlying instance and OS.

Remember target platform selection should not be decided solely based on the below chart, because choosing a target platform should not be done only by evaluating database features and dependencies. We also need to take into account many other important factors like infrastructure, application compatibility, support requirements after migration, business needs, cost, and so on. 

Azure Target Platform Selection Chart:

This chart helps as a starting point in deciding which target platform in Azure suits to your existing on-premise environment.

Note: This chart gives you only a high-level idea of which target platform can be selected, but many many other parameters need to be considered before finalizing the target platform. Please evaluate all the parameters as per your environment and decide the target platform.

AzureSQL Database vs Azure SQL Managed Instance vs SQL Server on Azure VMs.

Thanks VV!!

#azure #databasemigration #azuremigration #sqlserver #sql #dbmigration #Azure #AzureSQL