In this article, we are going to learn how to build the SQL Database in Azure in a PaaS model.
When we say PaaS model, we are actually talking about a fully managed Platform-as-a-Service (PaaS) database engine that handles many of the database management functions (upgrading, patching, backups, and monitoring ) without any user involvement. Let's see the steps to create the single SQL database below one by one.
Log into the Azure portal with valid User Id and subscription.
After logging in, please make sure you have created the valid resource group. To start creating the database, select Azure SQL in the left-hand menu and click Add to select the SQL deployment option page.
When you click on the Add icon, it will navigate to the page asking you to select the tile with multiple options. In our case, we are going to create the SQL Single Database, select "Create".
Clicking on Single Database Resource type create button navigates to the basics tab to enter the subscription and resource group.
Choose valid subscription and resource group here.
In the Database details, enter the database name and in the server details, click "Create New" and provide valid details in the below sections.
- Server Name
- Server admin login
- Type complex password
- Location
After providing the database and server details, you will be having the page something like below.
Here, we want to use the SQL elastic pool section. Select the No option.
And in Compute + Storage section Select Configure Database.
Once you click on configure database, it will navigate to the new page and asking you to select the tier and generation. Select the required details and click Apply.
After applying that, select Additional settings tab. Here in the data source section, under existing data, select sample and leave the rest of the value as it is.
Finally, review the final settings and click create. This will initiate the deployment to create the database.
Once the deployment is done you will get an alert on the page saying the deployment is complete.
That's it!! We have successfully created a single database in the Azure portal. Using the same method, we can import any existing database in Paas. In our next article, we are going to see how to login into the database and execute the query in the same Azure Portal.
Thanks for your support!!