How do I rename an Azure SQL Database?

Posted by

From time to time I need to do those kind of things, so I want to keep it posted here to no to forget them.

If I need to rename a database which is in Azure Database, I have two options to do this, bot options are related with Management Studio, so keep in min to have in your laptop and keep in mind that your IP has to be allowed to connect to the database server.

Rename with command-line – TSQL

  1. Connect with SQL Server Management Studio to your Azure database server
  2. Right-click on the master database and select New Query
  3. In the New Query window type ALTER DATABASE [dbname] MODIFY NAME = [newdbname]. (Make sure you include the square brackets around both database names.)

Rename with a GUI – SQL Server Management Studio

  1. Connect with SQL Server Management Studio
  2. Make sure Object Explorer pane is open.
  3. Click on the database name (as the rename option from the dropdown will be greyed out) and type in the new name.
  4. The Azure Portal should show the reflected the change almost immediately.

One comment

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s