topic Re: Create geodatabase on desktop SDE in Python Questions

Create geodatabase on desktop SDE

PaulKroseman — Mon, 18 May 2015 19:14:34 GMT

Does anyone have a script or know which geoprocessing tool to reference to create a geodatabase on the desktop version of SDE? (10.3)

Re: Create geodatabase on desktop SDE

AlexanderNohe1 — Mon, 18 May 2015 19:58:08 GMT

I believe that you are looking for the following help documentation:

Create Enterprise Geodatase (Data management)

Create Enterprise Geodatabase—Help | ArcGIS for Desktop

Re: Create geodatabase on desktop SDE

FreddieGibson — Mon, 18 May 2015 19:58:26 GMT

I believe you're looking for one of the following tools.

Create Enterprise Geodatabase

http://desktop.arcgis.com/en/desktop/latest/tools/data-management-toolbox/create-enterprise-geodatabase.htm

Enable Enterprise Geodatabase

http://desktop.arcgis.com/en/desktop/latest/tools/data-management-toolbox/enable-enterprise-geodatabase.htm

Re: Create geodatabase on desktop SDE

PaulKroseman — Mon, 18 May 2015 20:48:43 GMT

I was thinking that but I could not find the authorization file to input. Where do you find the authorization file for the desktop install?

Re: Create geodatabase on desktop SDE

FreddieGibson — Mon, 18 May 2015 20:51:24 GMT

You should see a keycodes file in a path similar to C:\Program Files\ESRI\License10.3\sysgen. This would be on a machine with ArcGIS Server installed.

Re: Create geodatabase on desktop SDE

PaulKroseman — Mon, 18 May 2015 21:02:30 GMT

I am using the SQL express database that comes with the Desktop package (Database_Server_Desktop_103_143531.exe). I can create geodatabases using the GUI as shown in the attachments without an authorization file. I wanted to script this process.

Re: Create geodatabase on desktop SDE

JoshuaBixby — Mon, 18 May 2015 21:03:30 GMT

Paul Kroseman, you are interested in Personal/Desktop SDE, right? The links being provided are for Enterprise SDE or enterprise geodatabases. Personal SDE or desktop geodatabases don't require additional keycodes like workgroup geodatabases and enterprise geodatabases. If you are interested in desktop geodatabases, check out Database Server (Desktop) installation guide. I don't think setting up desktop geodatabases is as scriptable as enterprise geodatabases, but I haven't looked into it completely.

Re: Create geodatabase on desktop SDE

FreddieGibson — Mon, 18 May 2015 21:13:02 GMT

Yea....I'm pretty sure we don't have any out-of-the-box tools or scripts that would allow you to do this outside of the GUI for personal sde.

Re: Create geodatabase on desktop SDE

PaulKroseman — Mon, 18 May 2015 21:16:49 GMT

Yes, I am looking at the Personal/Desktop SDE. I have it setup and working but I would like to script the creation of geodatabases. I find it odd that scripting would not be supported or requires an ArcGIS Server license.

Re: Create geodatabase on desktop SDE

PaulKroseman — Mon, 18 May 2015 21:23:23 GMT

Freddie Gibson wrote:
Yea....I'm pretty sure we have any out-of-the-box tools or scripts that would allow you to do this outside of the GUI for personal sde.

I'm sure you meant "we don't have any".

Re: Create geodatabase on desktop SDE

FreddieGibson — Mon, 18 May 2015 21:36:13 GMT

Correct. That's what I meant to say.