Allow users to rename their SQL Server geodatabase

4067
9
03-31-2010 01:31 PM
Status: Implemented
Labels (1)
by Anonymous User
Not applicable

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

Tags (2)
9 Comments
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

by 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.

NanaDei
Status changed to: Under Consideration
 
KoryKramer
Status changed to: In Product Plan
 
KoryKramer
Status changed to: Implemented

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