Introduction
In my previous blog, you saw how to create an Azure SQL database and to query the database on the Azure portal. Azure SQL Database is a relational Database-as-a-Service which provides high performance, reliable, and secure database used to build data-driven applications and websites. You can either use Azure cloud shell to run PowerShell from your browser or you can install it on your computer. In this blog, you will see how to perform the following tasks for the specific resource group and server using PowerShell.
- Get SQL Databases
- Create a new database
- Set properties for a database
- Remove an SQL database
SQL Server Details
Log in to the Azure Portal.
Click SQL Databases -> vijaiDB (which I have created in my previous article). Click Overview and you could see the server name and resource group which will be required for managing the SQL databases using PowerShell.
Open PowerShell from your browser
Log in to the Azure Portal.
Click Cloud Shell and then click PowerShell.
Create Storage and once the storage is created, it will take a few minutes for the Cloud Shell to open the PowerShell session.
Get-AzureRmSqlDatabase cmdlet will get the database for the specific server and resource group.
- PS Azure:\> Get-AzureRmSqlDatabase -ResourceGroupName "myResourceDB" -ServerName "mysqldbserver20171103"
- PS Azure:\> Get-AzureRmSqlDatabase -ResourceGroupName "myResourceDB" -ServerName "mysqldbserver20171103" -DatabaseName "vijaiDB"
New-AzureRmSqlDatabase cmdlet will create a new database on a specific server.
- PS Azure:\> New-AzureRmSqlDatabase -ResourceGroupName "myResourceDB" -ServerName "mysqldbserver20171103" -DatabaseName "vijaiDB001"
Set-AzureRmSqlDatabase cmdlet will set the properties for existing SQL database.
- PS Azure:\> Set-AzureRmSqlDatabase -ResourceGroupName "myResourceDB" -ServerName "mysqldbserver20171103" -DatabaseName "vijaiDB001" -Edition Basic
Remove-AzureRmSqlDatabase cmdlet will remove the database from the specific resource group and server.
- PS Azure:\> Remove-AzureRmSqlDatabase -ResourceGroupName "myResourceDB" -ServerName "mysqldbserver20171103" -DatabaseName "vijaiDB001"
Result
Thus, in this blog, you saw how to manage Azure SQL Database using PowerShell.