Click here to Skip to main content
15,867,568 members
Please Sign up or sign in to vote.
1.00/5 (1 vote)
See more:
Hi,

How to rename SQL azure database in production. Is there any impact after renaming the database in production SQL azure database. Please give me solution asap.

Thanks in advance.

Thanks,
Sree DBA.
Posted

1 solution

The step to rename the database is quite straightforward. Look here:

ALTER DATABASE [dbname] MODIFY NAME = [newdbname]


http://azuregeek.com/how-to-rename-database-in-sql-azure[^]

As far as the impact is concerned, it's impossible to tell from here.

Start asking questions to your colleagues and other application admins, such as which application(s) are using this database. Where is the connection string defined? Who is going to take care of that?
 
Share this answer
 
Comments
SreeDBA 19-Nov-14 15:35pm    
Thanks Manas. The dbname name changed successfully but i want to know the impact on tables and schema!
Manas Bhardwaj 19-Nov-14 15:40pm    
There is no direct impact of SQL DB rename on tables and schema specifically.
SreeDBA 19-Nov-14 16:17pm    
Thanks Manas.
Maciej Los 19-Nov-14 16:04pm    
+5
Manas Bhardwaj 19-Nov-14 16:05pm    
thx!

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900