How to migrate from Azure SQL Database to Azure SQL Managed Instance

We have a around 100 databases in Azure SQL database on one logical sql server in one elastic pool. The database range from ~5GB to 400GB in size.

We want to migrate all databases to Azure SQL Managed Instance due to reasons like better cross-database support, SQL Server agent etc.

While there is a ton of resources how to migrate eg. from on-prem SQL server to Azure SQL, there is nothing apart from (dump to bacpac and import again).

What is the recommended way to perform such a migration?

Read more here: Source link

How to migrate from Azure SQL Database to Azure SQL Managed Instance

We have a around 100 databases in Azure SQL database on one logical sql server in one elastic pool. The database range from ~5GB to 400GB in size.

We want to migrate all databases to Azure SQL Managed Instance due to reasons like better cross-database support, SQL Server agent etc.

While there is a ton of resources how to migrate eg. from on-prem SQL server to Azure SQL, there is nothing apart from (dump to bacpac and import again).

What is the recommended way to perform such a migration?

Read more here: Source link