0

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"

Improve this question
1
  • Have you tried using the GUI to export a bacpac and import that into your managed instance? Does that give you any error details? – HandyD Feb 4 '20 at 0:17
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

Improve this answer

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.