azureazure-sql-databaseazure-elasticpool

Azure: How to move databases into Elastic Pool

We have a few databases in Pricing Tier: Basic, S0... like below picture:

enter image description here

These databases were created before a new Elastic Pool is created. Now we want to move these databases into Elastic Pool for costing saving. But it seems I don't know how to move them on the Azure portal.

Solution

  • You can create an elastic pool in the same server as your databases, through portal using instructions here - https://azure.microsoft.com/en-us/documentation/articles/sql-database-elastic-pool-create-portal/

    Once you have created a pool, you can add existing databases to the pool using instructions here - https://learn.microsoft.com/en-us/azure/sql-database/sql-database-elastic-pool#manage-an-elastic-pool-and-its-databases

    Let us know if you have any further questions here.

    -- srini