How do you move a Elastic pool Database to a Manages SQL database

Question

Hi, I am trying to move an elastic pool database to a managed pool one. Whats the best way?

Answer 1

The destination is a managed instance.

Answer 2

If you want to migrate data and programming objects, you can use SqlPackage utility as explained in this article. You can also use Export/Import Data-Tier Application Wizard in SQL Server Management Studio (SSMS) which uses SqlPackage behind the scenes.

If you would like to move the data of the database only from elastic pools to managed instance, then you can use SSIS Export/Import Data Wizard in SSMS.

I can only suggest you those 2 ways (above) as Azure Data Migration Service (DMS), Data Migration Assistant (DMA), native SQL backups are not available in this scenario. In addition, Azure SQL elastic pools cannot be used as a source for database Mirroring, Always On, Transaction Log Shipping, or Transactional Replication.

You can certainly use T-SQL, Azure Data Factory and SQL Server Integration Services in this scenario, but it may be time consuming, complicated and require some development.

Answer 3

Hi @Scott Elmore Depending on the size, complexity and used features - some of the ways would be:

BACPAC
SSIS Packages / ADF
Linked Server from the SQL MI
Here is the link with description of some of the paths - Planning a Migration from Azure SQL DB to Azure Managed Instance – Eitan Blumin's Blog

Big Thanks to @Alberto Morillo for your contribution.

Hope that also help

Regards,
Oury