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?
Best Answer
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.