Posts

Showing posts from January, 2015

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.