Allow users to rename their SQL Server geodatabase

[Anonymous User]

Allow users to rename their SQL Server geodatabase. Some scenarios of why this functionality would be needed are as follows:
- backing up a production database and restoring it as test or development database with a new name
- restoring an ArcSDE geodatabase within the same SQL server instance to recover lost data
- the need to change the name of the ArcSDE geodatabase after repository tables have been populated

[NickFloersch]

I sure would find this handy... yes you can do it now, but it involves way too much complexity and pain. This seems like it should be an easy task.

[SandyDavis]

Definitely a major piece of functionality needed.  Not only for SQL Server, but for all other databases as well.  We run DB2.

[MatthewDobson]

There are ways of creating a copy of a database with a different name via database tools now - restore to an additional instance, create an empty database then use ArcCatalog to migrate the data. 

It's not an easy task, but then again that's why we have DBA's. 

Sorry, Matthew

[Anonymous User]

Or what if any mention of the database were removed from the gdb_items, sde_table_registry etc. ?  In general it seems odd to require an item in a container to reference the name of the container it sits within.  If really needed, maybe views could be used that compute the value based on databasename?

[DebbieBull]

The ability to rename a database is an essential Database Administration utility. Esri should support this functionality with Geodatabases, if not directly supporting the database rename via "ALTER DATABASE <current_name> Modify Name = <new_name>" then with via a tool and scripting/coding for the SDE internals updates. This is a painful shortfall for those of us who need to administer geodatabases.

[KoryKramer]

This ability has been added in ArcGIS Pro 3.0. See the What's new documentation: https://pro.arcgis.com/en/pro-app/latest/get-started/whats-new-in-arcgis-pro.htm

Also be sure to look at what other ideas you can expect to see when you update by reading Ideas in ArcGIS Pro 3.0 

[ShannonShields]

This post covers renaming a SQL Server database in more detail: https://www.esri.com/arcgis-blog/products/arcgis-pro/data-management/restoring-sql-server-databases-...