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
  2. Really I enjoy your blog with an effective and useful information. Very nice post with loads of information. Thanks for sharing with us..!!..Azure Online Course

    ReplyDelete
  3. very useful blog to learner so happy to be part in this blog. Thank you.
    Amazon Web Services Online Training

    ReplyDelete

Post a Comment

Popular posts from this blog

Server Manager Refresh completed with one or more warning

Shrewsoft VPN client - can't open Access Manager

Hyper-V could not replicate changes for virtual machine as replication is suspended on the Replica server