In this hands-on lab scenario, your organization, Awesome Company, is reducing its on-site footprint and moving as many databases as possible to the cloud. Part of this project involves migrating multiple local SQL Server databases to Azure. As Database Administrator, it’s your responsibility to set up the Azure SQL Database resources necessary for this migration. By performing the actions of this lab, you become familiar with creating an Azure SQL Server, creating a single Azure SQL Databases, and creating an Azure SQL Elastic Pool.
Learning Objectives
Successfully complete this lab by achieving the following learning objectives:
- Create the HR Database and Its Server
- Once you’re logged into the Azure portal, click on the three-bar menu create a resource.
- Click SQL Database, on this page type:
- Resource Group: Select pre-existing group in list
- Database name: HR
- Server: Create new
- Server name: acsql-7777
- Server admin login: Delmar
- Password and Confirm password: input a password
- Click OK.
- Select Configure database.
- Select basic, standard premium.
- Standard is selected by default, click Apply.
Click review and create and click create.
Note: This will take a moment to complete.
- Select go to resource to see the HR database.
- Create the Development Databases and Their Elastic Pool
We create three development databases (DEV1, DEV2, DEV3) and an elastic pool to allow them to share resources.
Note: When creating these database it may take some time for the dropdowns to have your select. Refresh the page if you encounter this.
Select the three-line menu and select create a resource and click SQL Database.
- Resource Group: Select pre-existing group in list
- Database name: DEV1
- Server: acsql-777
- Want to use SQL elastic pool? select yes
- Elastic pool: create new
- Enter an elastic pool name: Dev Pool and click OK
- Click Configure elastic pool
- Select basic, standard premium.
- Standard is selected by default, click Apply.
Click review and create and click create.
Note: This will take a moment to complete.
Select the three-line menu and select create a resource and click SQL database.
- Database name: DEV2
- Elastic pool: select DEV Pool
Click review and create and click create.
Note: This will take a moment to complete.
Select the three-line menu and select create a resource and click SQL database.
- Database name: DEV3
- Elastic pool: select DEV Pool
Click review and create and click create.
Note: This will take a moment to complete.
Select the three-line menu and select SQL databases.
Take notice on this page of all the SQL databases that you have provisioned. There should be four databases listed (three DEVs and one HR Database).
