Database properties

The Database Properties dialog box provides information about the database or geodatabase to which you're connected. You can access properties for the following in your project:

  • File geodatabases
  • Database connections, which include enterprise geodatabases and databases
  • SQLite database files and OGC GeoPackage files

The properties listed on the dialog box vary for each of these.

Properties applicable to all databases and geodatabases

The following properties apply to all connections.

Name

This property displays the directory path for the database to which you're connected. This path is the location where the file geodatabase, SQLite database, or GeoPackage is stored. For enterprise geodatabases and databases, this is the location of the database connection (.sde) file.

Type

The Type property on the Database Properties dialog box indicates whether you are connected to a file geodatabase, an SQLite database (which includes GeoPackage files), or a specific database management system. If the database management system has geodatabase capabilities enabled, the Type property will also indicate that.

Learn more about the types of geodatabases and databases and ArcGIS.

Properties specific to geodatabases

If you are connected to a geodatabase, the Database Properties dialog box will describe whether the geodatabase is a replica involved in a distributed data workflow.

Geodatabase replication is a data distribution method provided through ArcGIS that allows you to distribute your data to different geodatabases, and synchronize changes made to the data in each geodatabase. For more information, see Geodatabase replication fundamentals.

Properties specific to enterprise geodatabases

When you connect to an enterprise geodatabase, the Database Properties dialog box displays the properties described in the following sections. When you connect as the geodatabase administrator, additional functionality is available to you from this dialog box.

Connections

As a geodatabase administrator, you can prevent new connections to the geodatabase by unchecking the Geodatabase is accepting connections option. Existing connections remain active but no new connections can be made.

Note:

The geodatabase administrator can always connect to the geodatabase regardless of how this property is set.

You might block new connections to an enterprise geodatabase before performing maintenance operations such as compressing, upgrading, or making a full backup of the geodatabase.

To view existing connections to the geodatabase, click the Show connected users and locks button. This opens the Geodatabase Administration dialog box, where you can view the connected users and their connection properties, as well as manage locks.

Click the Locks tab of the Geodatabase Administration dialog box to view geodatabase locks held by each user.

If you connect as the geodatabase administrator, you can disconnect users to manage geodatabase locks from the Geodatabase Administration dialog box.

Upgrade status

Upgrading a geodatabase allows you to use the functionality available in the latest release of ArcGIS. The Upgrade Status property of the Database Properties dialog box displays the version of the geodatabase. It provides an option to upgrade if the geodatabase is eligible for an upgrade and if you connected as the geodatabase administrator.

Enterprise license expiration

This property displays the expiration date for the ArcGIS Server license stored in your enterprise geodatabase. If you connect as the geodatabase administrator, this property also provides a way to update the license before it expires.

To update the license, click the Update License button, browse to your new ArcGIS Server keycodes file, and click Open.

A keycodes file is created when you authorize an ArcGIS Server installation. You may need to copy the file from the ArcGIS Server machine and place it in a directory you can access from the ArcGIS Pro machine.