1

We need to migrate one of the database into MI from Azure Sql. Has anyone done it before.Looking for any documenatation/Guidance on this as not much is available. Will be testing the below method soon.

One way would be to import the bacpac to blob and then use to restore in the MI. Any suggestions?

2
  • what do you mean by managed instance? Physical named instance?
    – CR241
    Mar 29, 2019 at 20:26
  • @CR241 : SQL Database Managed Instance. Apr 1, 2019 at 7:54

1 Answer 1

2

Since the Managed Instance was in preview, the first option we have is to export your Azure SQL Database as a bacpac then import that bacpac to your Managed Instance.

A better option we have now is using the Azure Data Migration service. It is not only faster than the method I described above, but it gives you the option to perform a data validation at end and it rebuilds all indexes on the database. Here you have a step-by-step tutorial.

3
  • 1
    I think these are the only 2 ways. Will mark it as answer if i do not find any other way. Apr 1, 2019 at 7:58
  • To my knowledge these are the only two methods to migrate from Azure SQL Database. The Data Migration Assistant does not support Azure SQL Database as a source. microsoft.com/en-us/download/details.aspx?id=53595 Apr 1, 2019 at 13:45
  • @Shanky Native SQL Server backups are not available on Azure SQL Database DTU model and vCore Model. They are available on Managed Instance. Apr 2, 2019 at 18:01

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

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