azure-data-factoryazure-sql-databaseazure-sql-managed-instance
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"
- Export the Data-tier to local disk from the Azure database. It will save a bacpac file.
Right click the database you need to export --> Task-->Export data-tier application and follow the steps until the bacpac file is created.
- Import the backpack file from the local disk to the On premises Instance by using the same utility from tasks.
Right click the database branch in your on premise instance --> Import data tier application and now use the bacpac file saved in first step to create the database.
I shared the case scenario with the Azure SQL Database team at Microsoft via an Exchange Mailing list for Azure SQL Databases contributors/MVPs. The answer provided by one of the managers of the team is the following: "Yes, transactional replication will be the best way at this point if they want to keep the replication running after the migration to Managed Instances."
Hope this helps.
Best Answer
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 :
SSDT
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