Explore Courses Blog Tutorials Interview Questions

Explore Tech Questions and Answers

Welcome to Intellipaat Community. Get your technical queries answered by top developers!

0 votes
by (45.3k points)

We have a few databases in Pricing Tier: BasicS0... 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.

1 Answer

0 votes
by (16.8k points)

You can perform the steps of Conversion of SQL Server Databases to Elastics pools (without changing your existing connection strings).

Requirements for this: 

First of all, make sure that, the Database is on the same SQL Server.

For instance, if you have multiple databases in your single server, then you can easily convert them into a single elastic pool.

If that is not the case, then simply create an SQL Server with Elastic Pool and transfer the databases into it, you'd require to make changes to the connection strings in your application which uses those databases.

So, for that, follow the steps below: 

Now first, creating a New SQL Elastic Pool.

Search for SQL Elastic Pools Service in the All Services , then enter "elastic pool and click on "SQL elastic pools".

Azure SQL Elastic PoolsAzure SQL Elastic Pools

Provide the name and select the subscription type, resource group, and your existing SQL Server:

New Azure SQL Elastic Pool

Now Configure your elastic pool by clicking on Configure Pool.

Configure Azure SQL Elastic PoolFrom the Resource Configuration & Pricing panel:

  • Select the tier across the top: Basic, Standard, Premium, or vCore for even more options
  • Under Pool Settings, you can set the Maximum DTUs and Data Size
  • The pricing for your selections appears in the Cost Summary box on the right

Now, add your Databases to the elastic pool > Click on "Databases" tab in order to add the databases to your Elastic Pool:

Add Databases to the Pool

Set the Per Database Settings > Third tab you can see here is "Per database settings", with this, you need to specify the minimum and max DTU, so as to allow for each DB:

Set Database DTU LimitsFinish

When it is done, press "Apply", it will save the configuration, then click on "Create", it will create the Elastic Pool.

It may take sometime, but after it is done, your DB will share the elastic pool.

SQL Azure Elastic Pool Overview

Browse Categories