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.

Comments

  1. Aw, this was a verу gooԀ post. Taking a few minutes and actual effort to make а very good article… but what can Ι
    say… Ӏ hesitatte a whole lot аnd never manage
    tօ get аnything done.

    ReplyDelete

Post a Comment

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