Migrating Azure SQL database to Azure sql Managed instance

Question

What are different options to move database from "Azure sql server" to "Azure sql managed instance", Looks like below options are not possible 1) Azure migration service - Not supporting azure sql server as source 2) bacpac and use sqlpackage to import, this is not working and getting struck with no result

only options i see is through Azure data factory with self hosted integration runtime

is there any better options to move from "Azure sql server" to "Azure managed instance"

Answer 1

The only way to go with this to get the bacpac file for your Azure SQL Database. Then import this bacpac file into your Managed Instance. This can be achieved through :

1. SSMS
2. Export\import using sqlpackage.exe
3. Via portal which appears to be a bit slow as the Azure SQL Database Import/Export service provides a limited number of compute virtual machines (VMs) per region to process import and export operations

4. SSDT

5. bcp

This link explains each method : Export bacpac

Once done. Import the bacpac file into your managed instance using SSMS,sqlpackage or portal.

This will walk you through the process : Import bacpac