question

ScottElmore-0703 avatar image
0 Votes"
ScottElmore-0703 asked OuryBa-MSFT commented

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

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

azure-sql-database
· 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.

The destination is a "managed pool" or managed instance?

0 Votes 0 ·
OuryBa-MSFT avatar image
0 Votes"
OuryBa-MSFT answered OuryBa-MSFT commented

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


· 3
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.

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

0 Votes 0 ·

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

0 Votes 0 ·

Thank you @OuryBa-MSFT for your contribution and your help.

0 Votes 0 ·
AlbertoMorillo avatar image
0 Votes"
AlbertoMorillo answered AlbertoMorillo edited

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.




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.

ScottElmore-0703 avatar image
0 Votes"
ScottElmore-0703 answered

The destination is a managed instance.

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.