idea Allow users to rename their SQL Server geodatabase in Data Management Ideas

Allow users to rename their SQL Server geodatabase

Anonymous User — Fri, 09 Sep 2022 21:54:14 GMT

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

Re: Allow users to rename their SQL Server geodatabase

NickFloersch — Mon, 05 Apr 2010 21:40:58 GMT

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.

Re: Allow users to rename their SQL Server geodatabase

SandyDavis — Tue, 20 Dec 2011 23:56:56 GMT

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

Re: Allow users to rename their SQL Server geodatabase

MatthewDobson — Tue, 04 Sep 2018 22:44:38 GMT

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

Re: Allow users to rename their SQL Server geodatabase

Anonymous User — Thu, 10 Oct 2019 18:19:22 GMT

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?

Re: Allow users to rename their SQL Server geodatabase

DebbieBull — Wed, 22 Jul 2020 16:27:42 GMT

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.

Re: Allow users to rename their SQL Server geodatabase - Status changed to: Under Consideration

NanaDei — Thu, 21 Oct 2021 19:47:43 GMT

Re: Allow users to rename their SQL Server geodatabase - Status changed to: In Product Plan

KoryKramer — Thu, 09 Dec 2021 18:54:26 GMT

Re: Allow users to rename their SQL Server geodatabase - Status changed to: Implemented

KoryKramer — Fri, 24 Jun 2022 12:39:11 GMT

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

Re: Allow users to rename their SQL Server geodatabase

ShannonShields — Wed, 29 Jun 2022 17:23:20 GMT

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-with-a-new-name/