Hi, I am trying to move an elastic pool database to a managed pool one. Whats the best way?
Hi, I am trying to move an elastic pool database to a managed pool one. Whats the best way?
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.
Hi @ScottElmore-0703 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 @AlbertoMorillo for your contribution.
Hope that also help
Regards,
Oury
Hi @ScottElmore-0703 Checking if you have any additional queries regarding the above. Please mark as accepted answer if the above replies were helpful. Otherwise let us know how we can better assist you.
Regards,
Oury
Hi @ScottElmore-0703 Checking if you have any additional queries regarding the above. Please mark as accepted answer if the above replies were helpful. Otherwise let us know how we can better assist you.
Regards,
Oury
10 people are following this question.