ArcGIS Pro

Restoring SQL Server databases with a new name

We are pleased to announce that database administrators can now change the database name when restoring or copying a SQL Server database that contains a geodatabase. We recognize that this has been a customer request for many years but, until now, changing the name of a database that contained an enterprise geodatabase was an unsupported operation because of references to the database name that were stored in system tables. The resolution for this was to modify the schema of several system tables in the geodatabase and change how ArcGIS qualifies the names of objects within the database.

This capability will exist in enterprise geodatabases in SQL Server that have been created or upgraded using ArcGIS Pro 3.0 or ArcGIS Server 11. Please be aware that only ArcGIS 10.7 or ArcGIS Pro 2.3 or newer clients can connect to and work with enterprise geodatabases in SQL Server that have been created or upgraded using ArcGIS Pro 3.0 or ArcGIS Server 11.

What differences can I expect after upgrading?

Why would I change the name of my database?

A few reasons why you might use a new name for a database when you restore it include:

What should I consider before changing the name of my database?

It is important to note that upgrading an enterprise geodatabase does not mean that you must change the database name; it only means that this capability is available. Changing the name of a SQL Server database that contains an enterprise geodatabase should not be a frequent practice and has similar impacts that can be expected when migrating the SQL Server instance to a new server name.

For example, you must repair the database source in map documents, projects, and layers. ArcGIS Server web services will also need to be republished. Changing the name of a database is equivalent to setting up a completely new enterprise geodatabase in terms of the impact on existing applications.

Reminder that ArcGIS clients older than ArcGIS Pro 2.3 or 10.7 applications will no longer be able to connect to geodatabases that have been created or upgraded using ArcGIS Pro 3.0 or ArcGIS Server 11 and subsequent client releases.

About the author

Product Engineer, Enterprise Spatial Database

0 Comments
Inline Feedbacks
View all comments

Next Article

The City of Newport News is Transforming Community Recreation

Read this article