The Enable Enterprise Geodatabase tool creates geodatabase system tables, stored procedures, functions, and types in an existing enterprise database, thereby enabling geodatabase functionality in the database.
- You must have ArcGIS for Desktop (Standard or Advanced), ArcGIS Engine Runtime with the Geodatabase Update extension, or ArcGIS for Server (Standard or Advanced) installed on the computer from which you will connect to the database and enable geodatabase functionality (create a geodatabase in the database).
Connect as the sde user to create a geodatabase in an IBM DB2, Informix, or PostgreSQL database. Connect as the sde user to create a master geodatabase in Oracle. Connect as a different schema owner to create a user-schema geodatabase in Oracle. You can connect as a user named sde or as a user who is dbo in the Microsoft SQL Server instance to create a geodatabase in a SQL Server database. Note that the SQL Server instance must use a case-insensitive collation.
The user who creates the geodatabase requires specific privileges. See the topic appropriate to your database for information on required privileges to create a geodatabase:
EnableEnterpriseGeodatabase_management (input_database, authorization_file)
Provide the path and connection file name for the database in which geodatabase functionality is to be enabled. The connection must be made as a user that qualifies as a geodatabase administrator.
Provide the path and file name of the keycodes file that was created when you authorized ArcGIS for Server Enterprise. This file is in the \\Program Files\ESRI\License<release#>\sysgen folder on Windows and /arcgis/server/framework/runtime/.wine/drive_c/Program Files/ESRI/License<release#>/sysgen directory on Linux. If you have not already done so, authorize ArcGIS for Server to create this file.
EnableGeodatabase example 1
This script uses an existing database connection file (my_db_connection.sde) located in the default ArcGIS for Desktop database connection location to enable geodatabase functionality with a keycodes file on a remote server.
##Import Arcpy module import arcpy arcpy.EnableEnterpriseGeodatabase_management("Database Connections\my_db_connection.sde", "//myagsserver/Program Files/ESRI/License10.1/sysgen/keycodes")
EnableGeodatabase example 2
This script uses an existing database connection file (database1.sde) in a user-defined location to enable geodatabase functionality with a keycodes file in a user-defined location on the local computer.
##Import Arcpy module import arcpy arcpy.EnableEnterpriseGeodatabase_management("C:\myconnections\database1.sde", "C:\authfiles\keycodes")
- ArcGIS for Desktop Basic: No
- ArcGIS for Desktop Standard: Yes
- ArcGIS for Desktop Advanced: Yes