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. AnonymousSeptember 20, 2017 at 1:47 AM

    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. UnknownSeptember 30, 2018 at 11:44 PM

    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. Azure DevOpsNovember 6, 2018 at 3:33 AM

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

    ReplyDelete
  4. Azure DevOpsNovember 30, 2018 at 2:14 AM

    very useful information, the post shared was very nice
    Microsoft Azure Online Training

    ReplyDelete

Post a Comment

Popular posts from this blog

Server Manager Refresh completed with one or more warning

The system cannot access one or more event logs because of insufficient rights The Problem: Configuration refresh message. The system cannot access one or more event logs because of insufficient rights, file corruption, or other reasons. For more information, see the Operation channel in the ServerManager-ManagementProvider error log on the target server. Problem occurred on Server 2012 servers that have been upgraded to Server 2012R2 servers. Servers are also clustered. The Solution: Following the event logs leads to a few registry keys. You can eliminate the messages by: 1. Export the following registry keys (for safety) 2. Delete the following keys: HKLM\SOFTWARE\Microsoft\Windows\CurrentVersion\WINEVT\Channels\Microsoft-Windows-DxpTaskRingtone/Analytic HKLM\SOFTWARE\Microsoft\Windows\CurrentVersion\WINEVT\Channels\Microsoft-Windows-IME-Roaming/Analytic HKLM\SOFTWARE\Microsoft\Windows\CurrentVersion\WINEVT\Channels\Microsoft-Windows-IME-SCDICCOMPILER/Analytic HKLM\SOFTWARE\Mic...
Read more

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

Image
EVENT ID 32088 for all VMs After running out of disk space on the Replica host server, all VMs stopped replicating.  Replication cannot simply be started by right clicking on the source VM and selecting Resume Replication. No console error message just the event log event 32088.  I considered removing replication and re-replicating but this seemed an awful lot of work for simple problem. Tried stopping the Hyper-V service on the replica host and restarting, but this also did not work. THE FIX 1. Go to the destination replica server, right click each VM and select Resume Replication.  2. Now you can go to the source server, right click each VM and select Resume Replication. For some strange reason this works. Just trying one end or the other will fail without a console error message (but shows in the event log).
Read more

Shrewsoft VPN client - can't open Access Manager

Shrewsoft VPN client - can't open Access Manager Problem Access Manager is not visible Occurred after adjusting using dual monitors. Reinstall does not fix the issue. The Fix Use regedit to rename or delete the following key: HKEY_CURRENT_USER\Software\ShrewSoft\vpn\user Had a look around the Shrewsoft support site - nothing useful in there to fix this problem.
Read more