How to rename a Microsoft Azure SQL database?
After getting hands dirty with nitty gritty of some of the Cisco Security portfolio,I am back with a unique topic,namely a SQL article that addresses another common scenario that people ask “How do I rename a Microsoft Azure SQL database”?
Introduction
SQL Database is a general-purpose relational database managed service in Microsoft Azure that supports structures such as relational data, JSON, spatial, and XML. SQL Database delivers dynamically scalable performance within two different purchasing models: a vCore-based purchasing model and a DTU-based purchasing model. SQL Database also provides options such as columnstore indexes for extreme analytic analysis and reporting, and in-memory OLTP for extreme transactional processing. Microsoft handles all patching and updating of the SQL code base seamlessly and abstracts away all management of the underlying infrastructure.
Azure SQL Database provides the following deployment options for an Azure SQL database:
As a single database with its own set of resources managed via a logical server
As a pooled database in an elastic pool with a shared set of resources managed via a logical server
As a part of a collection of databases known as a managed instance that contains system and user databases and sharing a set of resources
Rename with command-line - TSQL
Connect via 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.
Thank you so much for reading! Let's share your knowledge with others by sharing this post! 😋 TRADEMARK LEGAL NOTICE All product names, logos, and brands are property of their respective owners in the Austria or other countries.All company, product and service names used on this website are for identification purposes only. Pheniix is notaffiliated with or an official partner of Cisco, CompTIA,Dimension Data, VMware, Amazon, Microsoft, Certified Ethical Hacker, (ISC)², Juniper, Wireshark, Offensive Security,Google, GNS3, F5, Python, Linux, Java, Openstack, Vagrant, Ansible, Docker, GIT, , Blockchain or other companies.Use of these names, logos, and brands does not imply endorsement.The opinions expressed on pheniix are personal perspectives and not those of Cisco , Dimension Data or any other company. Pheniix runs as an independent blog.
#SQL #Database #Microsoft #MicrosoftAzure #SQLServerManagementStudio #JSON #AzureSQLdatabase