Create, Copy, Rename And Delete SQL Database In Azure

In this article, you will learn how to create, copy, rename and delete a SQL database in Azure.

Introduction 

 
In this article, I will discuss how to create, copy, rename and delete the sql database in Azure.
 
Prerequisites
  • Microsoft Azure account.
  • Sql server management studio.

Agenda

  • Create sql database.
  • Copy sql database.
  • Rename sql database.
  • Delete sql database.

Create SQL Database

 
Below, I will explain how to create a sql database in the Azure portal.
  • Open Azure portal and login with proper credentials.
  • Go to sql databases.
  • Click on add and a new popup will come.
  • In the popup, add database name, subscription, select resource group, select source, select server, select option of sql elastic pool, select pricing tier, select collation (case sensitive or case insensitive) and click on create which is shown in below figure,



  • It will take some time to create a sql database and after that, the database will show under sql databases section.

Copy SQL Database

 
Below, I will explain how to copy a sql database in the Azure portal,
  • Open Azure portal and login with proper credentials.
  • Go to sql databases.
  • Select the existing database, go to Overview option and click on the copy which is shown in the below figure,



  • A new popup will come, in that add database name, select target server, select elastic database pool, select pricing tier and click on ok which is shown in the below figure,

     
It will take some time to copy the sql database and after that, the database will show under the sql databases section.
 

Rename SQL Database

 
Below, I will explain how to rename a sql database in the Azure portal.
 
In Azure, there is no option available to rename an existing sql database in the portal.
 
But we can still do that, which is explained below,
  • Open sql server management studio.
  • Provide server name (azure server name), login, password and click connect.
  • Select the database which you want to rename from databases section.
  • Press F2, give a new name and press enter.
  • Or right-click on the database, click rename, give a new name and press enter.
After that, go to Azure portal and there you can see the database name has been changed.
 

Delete SQL Database

 
Below, I will explain how to delete a sql database in the azure portal.
  • Open Azure portal and login with proper credentials.
  • Go to sql databases.
  • Select the database which you want to delete and click on the overview.
  • After that a delete button will display and which is shown in below figure,



  • Click on delete button and after that, a new pop up will come from the right-hand side.
  • In the textbox, type the database name and click on delete button and which is shown in below figure,

     
 After that, it will take some time and the database will permanently delete from the server.