topic Re: Esri dropping shp2sde at ArcGIS 10.1? in Data Management Questions

Esri dropping shp2sde at ArcGIS 10.1?

MikeStaley — Fri, 06 Jan 2012 15:58:33 GMT

I just found the following note in Esri???s Deprecation Plan for ArcGIS 10.0 and ArcGIS 10.1:

??? [Added 8/18/2011] ArcGIS Server 10.1???s ArcSDE technology component will no longer support
32???bit versions of the SDE command line utilities or 32???bit versions of the C and Java APIs. With
the migration of ArcGIS Server to be 64???bit, the SDE command line utilities and the ArcSDE SDK
will be 64???bit only.

shp2sde was available in the 32-bit version, but not the 64-bit version, of ArcGIS Server 10.0.

Does this mean that shp2sde is no longer available at ArcGIS 10.1?

Re: Esri dropping shp2sde at ArcGIS 10.1?

AlexeyTereshenkov — Sat, 07 Jan 2012 10:34:15 GMT

Hi,

As far as I know, the command line utilities will be available in ArcGIS 10.1 and will be installed separately by using the special "ArcSDE administration command line tool installation". What I know, however, is a subject to change since I am talking about ArcGIS 10.1 beta 2.

For instance, you will get ArcSDE Command Line Tools for Windows 64 bit installation. However, some commands cannot be used on specific operating systems. These are as follows:
Linux 64-bit: cov2sde and sde2cov
HP Itanium: cov2sde, sde2cov, sde2shp, shp2sde, sde2tbl, tbl2sde, and shpinfo

What I can read from the ArcSDE Administration Command Reference of the ArcGIS 10.1 beta 2 is that shp2sde: "This function is not supported on HP-Itanium", which implies that it will be supported for Windows 64bit.

Let Esri staff correct me if I got something wrong.

Re: Esri dropping shp2sde at ArcGIS 10.1?

MikeStaley — Mon, 09 Jan 2012 15:52:51 GMT

Alex, thanks for the info and quick reply...Mike

Re: Esri dropping shp2sde at ArcGIS 10.1?

MikeStaley — Wed, 11 Jan 2012 14:05:08 GMT

Follow up.

A response from an Esri Account Manager about shp2sde availability at ArcGIS 10.1:

"Since shp2arc is a command-line SDE command based on Workstation ArcInfo, I would not expect it to get �??enhanced�?� to support 64-bit OSs. This is one of six SDE commands that fall into this category."

This statement, coupled with the following Q&A item from Esri�??s 2011 International User Conference, strongly indicates to me that shp2sde (and perhaps cov2sde, sde2cov, sde2shp, sde2tbl and tbl2sde) will not be available at ArcGIS 10.1.

http://events.esri.com/uc/QandA/index.cfm?fuseaction=answer&conferenceId=DD02CFE7-1422-2418-7F271831F47A7A31&questionId=4000

Re: Esri dropping shp2sde at ArcGIS 10.1?

VinceAngelo — Wed, 11 Jan 2012 17:17:25 GMT

If push comes to shove, I think I could extend the Generic SDE Loader in 'se_toolkit'
to read a shapefile in a simple table loader ('shpfile2sde'). Basic functionality isn't more
than a day's effort, but if you're dependent on "insert_or_update" or some of the more
exotic capabilities, you'll probably want to work this from the Marketing/Tech Support
side for a supported tool.

- V

Re: Esri dropping shp2sde at ArcGIS 10.1?

MikeStaley — Thu, 12 Jan 2012 14:53:18 GMT

Vince,

If you're proposing to extend se_toolkit and create a shpfile2sde binary command line utility, I'm all in. What do I have to do?

I haven't used the se_toolkit, so I quickly reviewed ftp readme and ArcScripts documentation. Looks like our product deployment meets se_toolkit requirements. Our target platform would be ArcGIS 10.1 on Windows Server 2008.

We don't use exotic capabilities of shp2sde, just append and init to add features.

Mike

Re: Esri dropping shp2sde at ArcGIS 10.1?

VinceAngelo — Thu, 12 Jan 2012 15:23:48 GMT

You don't need to do anything yet. I augmented the 'se_toolkit' shpfile.lib to support read
access back in August, so I just need some hobby time (when not working weekends or
repainting the bathroom) to modify the 'asc2sde.c' template into 'shpfile2sde.c'. The first
iteration won't support column renaming (-a file=...), but basic '-o {create | init | append}'
should be doable. I'll let you know when 'setk100b10' is released (hopefully before 10.0sp4
ships).

- V

Re: Esri dropping shp2sde at ArcGIS 10.1?

KimPeter — Sat, 14 Jan 2012 21:20:44 GMT

...some commands cannot be used on specific operating systems. These are as follows:
Linux 64-bit: cov2sde and sde2cov
HP Itanium: cov2sde, sde2cov, sde2shp, shp2sde, sde2tbl, tbl2sde, and shpinfo

You are correct, Alex. The operating system/command line utility combinations you have listed are the only ones that are not supported for 10.1.

-Kim

Re: Esri dropping shp2sde at ArcGIS 10.1?

AmayaMateos — Wed, 19 Sep 2012 11:20:04 GMT

You are correct, Alex. The operating system/command line utility combinations you have listed are the only ones that are not supported for 10.1.

-Kim

And how i could put load my shapefiles into my geodatabase with arcsde commands?

Best regards...

Re: Esri dropping shp2sde at ArcGIS 10.1?

VinceAngelo — Wed, 19 Sep 2012 13:00:16 GMT

If it's a geodatabase, then you really ought to be using ArcGIS tools (Desktop / Catalog / arcPy)
to load shapfiles. The command-line 'shp2sde' is still supported for simple feature class creation
on the most common platforms at 10.1 (HP/UX Itanium is the only platform not supported).

- V

Re: Esri dropping shp2sde at ArcGIS 10.1?

AmayaMateos — Thu, 20 Sep 2012 05:31:21 GMT

If it's a geodatabase, then you really ought to be using ArcGIS tools (Desktop / Catalog / arcPy)
to load shapfiles. The command-line 'shp2sde' is still supported for simple feature class creation
on the most common platforms at 10.1 (HP/UX Itanium is the only platform not supported).

- V

And if i have intel platform and win 2008 64 bits OS? And is it the same in the 10.0 version?

Re: Esri dropping shp2sde at ArcGIS 10.1?

VinceAngelo — Sat, 11 Dec 2021 12:25:15 GMT

The shapefile tools were not released in 64-bit with Windows at 10.0, but they do exist
in 64-bit at 10.1.

You can still use the 32-bit binaries on Windows at 10.0. HP/UX is the only OS where
you can't fall back to the 32-bit install. In my testing, the 32-bit binaries were a bit
faster than the equivalent 64-bit tools. You just need to make sure that the 32-bit
libraries are first in the PATH:

@echo off
REM shp2sde.bat
set SDEHOME=D:\Esri\arc100ora11g32-sp5\ArcSDE\ora11gexe
set PATH=%SDEHOME%\bin;%PATH%
%SDEHOME%/bin/shp2sde %*

- V