topic Re: Create Enterprise Geodatabase with arcpy - No command options given in Data Management Questions

Create Enterprise Geodatabase with arcpy - No command options given

BatbayarJargalsaikhan1 — Sat, 28 Jun 2014 06:10:55 GMT

hi, I'm trying to create geodatabase using python first time. i used script in installation guide. but getting following error:

C:\Users\Administrator\Desktop\geodatbase.py: error: No command options given

Usage: geodatbase.py [Options]

Options:
--version show program's version number and exit
-h, --help show this help message and exit
--DBMS=SQLSERVER Type of enterprise DBMS: SQLSERVER, ORACLE, or
POSTGRESQL.
-i MSSQLSERVER DBMS instance name
-D NGDB Database name: Not required for Oracle
--auth=DATABASE_AUTH Authentication type options (case-sensitive):
DATABASE_AUTH, OPERATING_SYSTEM_AUTH.
Default=DATABASE_AUTH
-U SA DBMS administrator user
-P sysadminpass DBMS administrator password
--schema=SDE_SCHEMA Schema Type for SQL Server geodatabase, SDE or DBO.
Default=SDE_SCHEMA
-u SDE Geodatabase administrator user name
-p SDEPASSWORD Geodatabase administrator password
-t Tablespace name
-l C:\PROGRAM FILES\ESRI\LICENSE10.2\SYSGEN\KEYCODES
Full path and name of authorization file

THANKS

Re: Create Enterprise Geodatabase with arcpy - No command options given

EmadAl-Mousa — Sat, 28 Jun 2014 08:02:24 GMT

Hi,

it seems you are missing flag parameters such as '-D' '-U' '-t'....etc in your python code.

why not use the geo-processing tool in ArcCatalog: http://resources.arcgis.com/en/help/main/10.2/index.html#//003n000000r7000000

Regards,

Re: Create Enterprise Geodatabase with arcpy - No command options given

VinceAngelo — Sat, 28 Jun 2014 20:46:15 GMT

The Python tool for Create Enterprise Geodatabase (Data Mangement) doesn't look anything
like what you've posted. Instead, it looks like you used a trivial wrapper around the 'sdesetup'
utility (which isn't available in modern versions of ArcGIS).

If you're using ArcGIS 10.1 or later, use the ArcPy tool; if you're using 10.0 or earlier, just use
the 'sdesetup' utility natively. Either way, you're going to need to provide required parameters.

- V

Re: Create Enterprise Geodatabase with arcpy - No command options given

ForrestJones — Mon, 30 Jun 2014 15:28:31 GMT

Hi jbatbayar,

The script you are running from the install guide takes in many parameters as the output shows. You just need to provide those for it to run - such as the type of DBMS (--DBMS), user name (-u), etc. It is in fact just a wrapper around the GP tool which you can also use.

Re: Create Enterprise Geodatabase with arcpy - No command options given

BatbayarJargalsaikhan1 — Tue, 01 Jul 2014 01:13:19 GMT

thanks all,

i used arcpy tool. thanks for useful information

Batbayar.J