Help

Upgrade Production Database

Summary

Upgrades a production database schema. A production database stores tables used by Esri Mapping and Charting Solutions. Esri Production Mapping, Esri Defense Mapping, and the ArcGIS for Aviation: Charting store different data models in their production databases. These data models describe hard-copy maps or charts based on product specifications.

Usage

  • The Workspace for Product Database must be a geodatabase that contains a production database. This tool upgrades the production database to the latest version.

  • Use a path to a connection file if Workspace for Product Database references an enterprise geodatabase. The user credentials in the connection file must have permission to create data in the workspace.

  • You can use a configuration keyword for file and enterprise geodatabases. Each geodatabase type and configuration supports different configuration keywords; however, personal geodatabases do not support keywords.

Syntax

UpgradeProductionDatabase(production_database_workspace, {database_config_keyword})
ParameterExplanationData Type
production_database_workspace

The workspace that will store the production database.

Workspace
database_config_keyword
(Optional)

Database storage or configuration keyword. The default is Defaults.

String

Code sample

UpgradeProductionDatabase example (stand-alone script)

The following stand-alone script demonstrates how to use the UpgradeProductionDatabase tool. The script upgrades a production database with a schema from a previous version.

# Name: UpgradeProductionDatabase_Example.py
# Description: Upgrades a production database in an existing file geodatababase to the current schema
# Requirements: Production Mapping extension

# import arcpy and checkout a Production Mapping license
import arcpy
arcpy.CheckOutExtension("foundation")

#Set local variables
productiondatabase_workspace = "C:\\Data\\ProductionDatabase.gdb"
database_config_keyword = "DEFAULTS"

# upgrades a production database
arcpy.UpgradeProductionDatabase_production(productiondatabase_workspace, database_config_keyword)

print "Script completed successfully."

# Check in the extension
arcpy.CheckInExtension("foundation")

Environments

Licensing information

  • ArcGIS Desktop Basic: No
  • ArcGIS Desktop Standard: Requires Production Mapping
  • ArcGIS Desktop Advanced: Requires Production Mapping

Related topics