How to Rename an Azure SQL Database using Visual Studio Web Express

Wanted to rename a database on Azure and could not find an option to do this in the Azure Portal.

From Visual Studio Web Edition

1. In the Server Explorer view, expand SQL Databases.
2. Right click and Open in SQL Server Object Explorer
3. Login, if needed
4. Right click the Server (not the database) and Click New Query
5. In the Query Window type: ALTER DATABASE [oldname] MODIFY NAME = [newname]

My refresh did not work correctly so close Visual Studio and reopen to see the result.
Refresh the Azure Portal screen to see the result as well.

Rename Database on Azure - Done.


Popular posts from this blog

Server Manager Refresh completed with one or more warning

Event ID 122 Access to Drivers on Windows Update Blocked by Policy - Fix Here

Hyper-V failed to enable replication on the Replica server for the Virtual Machine