topic Re: Confusion over 10.2.2 ArcSDE command line tool location in ArcGIS Enterprise Questions

Confusion over 10.2.2 ArcSDE command line tool location

Anonymous User — Tue, 20 Oct 2015 16:20:30 GMT

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.

Re: Confusion over 10.2.2 ArcSDE command line tool location

QuinnFrancis — Tue, 20 Oct 2015 16:48:10 GMT

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

Re: Confusion over 10.2.2 ArcSDE command line tool location

RebeccaStrauch__GISP — Tue, 20 Oct 2015 16:49:25 GMT

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.

Re: Confusion over 10.2.2 ArcSDE command line tool location

Anonymous User — Tue, 20 Oct 2015 16:53:57 GMT

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.

Re: Confusion over 10.2.2 ArcSDE command line tool location

Anonymous User — Tue, 20 Oct 2015 16:55:04 GMT

*Server for Workgroup

Re: Confusion over 10.2.2 ArcSDE command line tool location

George_Thompson — Tue, 20 Oct 2015 17:00:19 GMT

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

Re: Confusion over 10.2.2 ArcSDE command line tool location

Anonymous User — Tue, 20 Oct 2015 17:02:42 GMT

That explains it, thanks George.