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

• simon coleman: I've automated this type of approach, works well. Performance depends on data volumes for larger (>Gb of data) but below that it's more driven by the time taken to transfer the schema

Answer 2

The best way is to make a snapshot copy, it's easier than exporting to ISPAC format https://learn.microsoft.com/fr-fr/azure/azure-sql/database/database-copy?view=azuresql&tabs=azure-powershell

• Community: As it’s currently written, your answer is unclear. Please edit to add additional details that will help others understand how this addresses the question asked. You can find more information on how to write good answers in the help center.