0

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?

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

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.

  • 1
    I think these are the only 2 ways. Will mark it as answer if i do not find any other way. – Ramakant Dadhichi Apr 1 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 – Alberto Morillo Apr 1 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. – Alberto Morillo Apr 2 at 18:01

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.