PAAS Migration -Migration from Azure SQL Single Instance /Azure VM to Azure Managed Instance

Ramya Lakshminath 21 Reputation points
2021-05-17T06:23:13.167+00:00

Could you please give some overview on the migration approach for Migration from Azure SQL Single Instance to Azure Managed Instance.
Could you please provide inputs on the following things:
Backup /restore strategy used for the migration.

Can we use Container stored backup files and restore to MI? If so what are the basic connection approach we need to follow.
Or
Should we go with DMS (offline). I tried this but no luck. Please explain what can be done.

I dint find any relevant content or approach on any blogs or site for this.

Regards,
Ramya

Azure Database Migration service
Azure SQL Database
Accepted answer
  1. KalyanChanumolu-MSFT 8,331 Reputation points
    2021-05-17T10:06:31.64+00:00

    @Ramya Lakshminath Welcome to Microsoft Q&A forums.

    You can export your Azure SQL Database to a BACPAC file and import it into managed instance.

    ----------

    If an answer is helpful, please "Accept answer" or "Up-Vote" which might help other community members reading this thread.
    And If you have further questions or issues please let us know.

    1 person found this answer helpful.

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.