Moving Databases into Azure SQL Elastic Pools

Quite a simple requirement (when I needed it a few months ago). Study my Azure SQL database environment below.

manyDBs

As you can see I have a standard elastic pool which has 7 databases within it. I also have CloudDB and CRMDB that are single databases but not yet part of my elastic pool. How do I move them into it?

Follow these steps.

  1. Find SQL elastic pools via the left menu navigation bar and click into it.

elasticpools

2. Click Configure Pool.

smarit

3. Click Add databases option.

addpools

4. Select the databases needed.

dbs

It will change to a pending state.

pending

Click SAVE – I used to miss this basic part and used to sit and stare at the screen wondering why it was still in a pending state!

save pool

Then once complete it will disappear – Simple. Connect to the master database via SSMS – (SQL Server Management Studio) and execute this query to understand how long the move will take.

SELECT * FROM sys.dm_operation_status

WHERE state_desc = 'IN_PROGRESS'

inprogress1

 

 

Advertisements

1 thought on “Moving Databases into Azure SQL Elastic Pools

  1. Pingback: Adding Database to Azure SQL Elastic Pools – Curated SQL

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s