Wednesday, 20 September 2017

RDS MSSQL Database name change or rename


How to change RDS MSSQL Database name

First you need to connect to the RDS MSSQL server

1.After connecting to RDS MSSQL server,
2.Open New Query window as master.
3.Copy and paste the below Query.
4.        EXEC rdsadmin.dbo.rds_modify_db_name N'OLD Databse name', N'New Database name'
        GO


Click Here!
5. Change the OLD database name as your existing database name.
6. change the New Database name as name you want to give to the database.

For example:
                     EXEC rdsadmin.dbo.rds_modify_db_name N'Reports', N'Reporting'
                     GO

That's it.

Please click on follow and put the suggestions in the comment section. Thanks.


No comments:

Post a Comment

Best Deals From Jabong Valentine Sale From 9 th FEB -12 th FEB up to 50-80% OFF Your Coupon Code: BEST15 https://www.rus...