Upgrade Production Database (Production Mapping)
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 an sde 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
| Parameter | Explanation | Data 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
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")