question

RamyaL-4293 avatar image
0 Votes"
RamyaL-4293 asked KalyanChanumolu-MSFT commented

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

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-sql-databaseazure-database-migration
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

KalyanChanumolu-MSFT avatar image
1 Vote"
KalyanChanumolu-MSFT answered KalyanChanumolu-MSFT commented

@RamyaL-4293 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.

· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Thank you Kalyan....Is there any option to do Online/Offline migration using DMS.

0 Votes 0 ·

@RamyaL-4293 Online/Offline migrations to Managed instance are possible when you are migrating from SQL Server on Azure VM.

Detailed tutorials are here.

Tutorial: Migrate SQL Server to an Azure SQL Managed Instance online using DMS
Tutorial: Migrate SQL Server to an Azure SQL Managed Instance offline using DMS

It is not possible to use DMS when migrating from Azure SQL Database because DMS requires access to full back up and log back up files.


If an answer is helpful, please "Accept answer" or "Up-Vote" which might help other community members reading this thread.

0 Votes 0 ·