Esri dropping shp2sde at ArcGIS 10.1?

[MikeStaley]

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?

[AlexeyTereshenkov · Accepted solution]

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.

[MikeStaley]

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

[MikeStaley]

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-7F271831...

[VinceAngelo]

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

[MikeStaley]

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

[VinceAngelo]

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

[KimPeter]

...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

[AmayaMateos]

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...

[VinceAngelo]

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