Move Azure Single Database to SQL Elastic Pool

AS I explained before in my previous articles How to provision Azure Single Database and How to Provision Azure SQL Database elastic pool today I will explain How we can move Azure Single Database to New Elastic Pool, For more information about Azure Database Deployment model Check this Post and If you are interested in More Azure Database Articles to check this Link and if you are Preparing for AZ-103 Azure Administrator Certification check this Article, In Microsoft documentation, you will find How to Provision Single Database or Elastic pool Server but you will note find information for How to move Single database to Elastic pool server

Case Scenario

Let us assume that we have 2 Azure Single Database Servers contain 3 Database with different Service Tier and we need to move them to Azure elastic pool

Moving Process

• You will need to Provision a new Azure Elastic pool by opening Azure MarketPlace and write on the search “SQL Elastic database pool” then Create
• Provide a name for Elastic Pool Name and it should be unique
• Select Server from the 2 Single servers you need to move the databases from it to Elastic Pool in my example I will select Server azuresinglelogic1 and this server contain two databases (azuresingle1 and azuresingle2)
• Select the Compute + storage either DTU or vCore
• When you open the configuration you will find 3 Options (Pool Setting, Databases, Per Database Setting)
• Pool Setting: you will configure the Compute + Storage from it
• Database: you will select the database you need to move it from the Single server to the new elastic pool we are creating it

• When done, press [Apply] to save the configuration, and [Create] to create the Elastic Pool it will take a few minutes and the two databases will be moved to an elastic pool

Validation

1. Open Azure portal and write on the search “SQL databases”
2. You will find two databases moved as below

Resources and References

• https://docs.microsoft.com/en-us/azure/sql-database/saas-tenancy-app-design-patterns
• https://docs.microsoft.com/en-us/azure/sql-database/sql-database-elastic-pool
• https://docs.microsoft.com/en-us/azure/sql-database/sql-database-elastic-pool-manage

Keep Following

• WordPress
• Facebook
• Twitter
• LinkedIn
• Link
• Link