Most folks aren’t aware of how powerful the Azure platform really is. As I’ve been presenting topics on Azure, I’ve had many people say, “How did you do that?” So I’ll be documenting my tips and tricks for Azure in these posts.
The Complete List of Azure Tips and Tricks
Rename an Azure SQL database
Last week, I did a SQL post on Easily reset the Administrator password for an Azure SQL database and it did rather well. So I’m back with another SQL post that addresses another common scenario that folks ask “How do I rename an Azure SQL database”?
Rename with command-line - TSQL
Connect with SQL Server Management Studio to your Azure database server
Right-click on the master database and select New Query
In the New Query window type
ALTER DATABASE [dbname] MODIFY NAME = [newdbname]. (Make sure you include the square brackets around both database names.)
Rename with a GUI - SQL Server Management Studio
Connect with SQL Server Management Studio
Make sure Object Explorer pane is open.
Click on the database name (as the rename option from the dropdown will be greyed out) and type in the new name.
The Azure Portal should show the reflected the change almost immediately.
Let me know in the commands if you want me to continue exploring Azure SQL. Thanks for reading!
Want more Azure Tips and Tricks?
If you’d like to learn more Azure Tips and Tricks, then follow me on twitter or stay tuned to this blog! I’d also love to hear your tips and tricks for working in Azure, just leave a comment below.