ArcGIS Desktop

  • ArcGIS Pro
  • ArcMap

  • My Profile
  • Help
  • Sign Out
ArcGIS Desktop

ArcGIS Online

The mapping platform for your organization

ArcGIS Desktop

A complete professional GIS

ArcGIS Enterprise

GIS in your enterprise

ArcGIS Developers

Tools to build location-aware apps

ArcGIS Solutions

Free template maps and apps for your industry

ArcGIS Marketplace

Get apps and data for your organization

  • Documentation
  • Support
Esri
  • Sign In
user
  • My Profile
  • Sign Out

ArcMap

  • Home
  • Get Started
  • Map
  • Analyze
  • Manage Data
  • Tools
  • Extensions

Upgrading the production database

Available with Production Mapping license.

The Upgrade Production Database command adds all the components necessary for your geodatabase to perform as a production database. This command is activated if there was an upgrade on the schema and your database is missing tables. It shows an Out of date message and is disabled.

If you are upgrading an enterprise geodatabase, you can only perform the upgrade if you connect as the schema owner for the workspace.

Caution:

The upgrade process needs an exclusive schema lock on all tables, so only one user can be connected to it. If someone else is trying to edit the tables, such as changing the associated data model versions, the schema locks conflict.

  1. Start ArcMap.
  2. If necessary, open the Product Library window by clicking Customize > Production > Product Library on the main menu.

    A tree view of the product library appears.

    Product library tree

  3. Define the product library workspace.
  4. Add data from the production database if you don't already have it loaded.
  5. Expand Production Data.
  6. Right-click the database and click Upgrade Production Database.

    The Upgrade Production Database Workspace dialog box appears.

  7. Click the drop-down arrow in the Select Configuration Keyword area and choose an option.

    Options may vary based on whether the database is a personal, file, or enterprise geodatabase. For an enterprise geodatabase, you can choose DEFAULTS unless you have configured a different geodatabase configuration keyword.

    • DEFAULTS—Stores data up to 1 TB in size; text is stored in UTF8 format.
    • TEXT_UTF16—Stores data up to 1 TB in size; text is stored in UTF16 format.
    • MAX_FILE_SIZE_4GB—Limits data size to 4 GB; text is stored in UTF8 format.
    • MAX_FILE_SIZE_256TB—Stores data up to 256 TB in size; text is stored in UTF8 format.
  8. Click OK.

    The Upgrading Production Database Workspace dialog box appears with the progress.

  9. Click OK when the process completes.

If the production database supports ArcGIS Defense Mapping, ArcGIS Production Mapping, ArcGIS Maritime, ArcGIS Bathymetry, or ArcGIS Aviation, it upgrades the tables that are part of the extension listed in the ToolTip. The production database also displays (Missing Extensions) next to Production Data if the production database supports a solution that is not installed.

Note:

For non-ArcGIS Maritime product libraries with a workspace schema prior to 10.1, the upgrade tool creates ArcGIS Maritime component tables by default to enable ArcGIS Maritime support in the product library workspace. For product libraries with a 10.1 or newer workspace schema, the upgrade tool upgrades these tables only if the ArcGIS Maritime extension is already being supported by the product library workspace.

ArcGIS Desktop

  • Home
  • Documentation
  • Support

ArcGIS

  • ArcGIS Online
  • ArcGIS Desktop
  • ArcGIS Enterprise
  • ArcGIS
  • ArcGIS Developer
  • ArcGIS Solutions
  • ArcGIS Marketplace

About Esri

  • About Us
  • Careers
  • Esri Blog
  • User Conference
  • Developer Summit
Esri
Tell us what you think.
Copyright © 2021 Esri. | Privacy | Legal