How To Manage Azure SQL Database Using PowerShell

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

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

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.