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!
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.
GO
That's it.
Please click on follow and put the suggestions in the comment section. Thanks.
No comments:
Post a Comment