You deploy Azure App Service Web Apps that connect to on-premises Microsoft SQL Server instances by using Azure ExpressRoute. You plan to migrate the
SQL Server instances to Azure.
Migration of the SQL Server instances to Azure must:
Support automatic patching and version updates to SQL Server.
Provide automatic backup services.
Allow for high-availability of the instances.
Provide a native VNET with private IP addressing.
Encrypt all data in transit.
Be in a single-tenant environment with dedicated underlying infrastructure (compute, storage)
You need to migrate the SQL Server instances to Azure.
Which Azure service should you use?
Azure SQL Database Managed Instance configured for Hybrid workloads. Use this topology if your Azure SQL Database Managed Instance is connected to your on-premises network. This approach provides the most simplified network routing and yields maximum data throughput during the migration.