Confusion over 10.2.2 ArcSDE command line tool location

[Anonymous User]

Hello - I need to create a view in a 10.2.2 SDE database. I have never used the ArcSDE command line tool and do not know where to find it. I tried this: ArcSDE application server for Microsoft SQL Server installation guide but in the setup I never saw the option to just install command line tools.

I'd really like to use the command line instead of the geoprocessing tool because of the issues described here: ArcGIS Idea - Create Views In ArcCatalog Like In SDE Command Line

I was reading this thread which got me on this tangent: Creating views in SDE 10.3

Thanks for any help.

[QuinnFrancis]

Hi Sarah,

You may have the command line tools installed on your machine already without you knowing.  Open up a command prompt and type in an ArcSDE command such as 'sdelayer' or 'sdemon'.  If information is returned regarding the command you typed in then you know the command line tools are installed.  Also, you can check the %SDEHOME%/bin directory on your machine to check if the tools are installed.  If the command tools are not installed, you can download them from the MyEsri site by navigating to My Organization > Downloads > ArcGIS for Server Enterprise > View Downloads.  Once installed, you'll want to run the 'sdetable -o create_view' command in a command prompt window.

ArcSDE Administration Command Reference

[RebeccaStrauch__GISP · Accepted solution]

The command line tools can be found on the MyEsri page.

If you have access to your agencies "MyEsri" for downloads, fselect the downloads for 10.2.x server (the last version that I think included the download)

Then download

EDIT: Quinn beat me to it.

[Anonymous User]

Oh interesting -- are they only available with the Enterprise license? We have Standard. I thought because our geodatabases are 'SQL Server Enterprise' that we'd be able to get the tools.

[Anonymous User]

*Server for Workgroup

[George_Thompson]

Hi Sarah,

The ArcSDE Commandline tools are only designed to work with Enterprise geodatabases, created with an ArcGIS For Server Enterprise license (an level), and NOT with ArcGIS Server for Workgroup. The Workgroup level geodatabases are based on SQL Server Express and not a "full" SQL Server version.

Hope this help....

-George

Geodatabase​

[Anonymous User]

That explains it, thanks George.