topic Re: using sdeimport to update an existing SDE layer w/an updated FC in Data Management Questions

using sdeimport to update an existing SDE layer w/an updated FC

BartPittari — Wed, 19 Aug 2015 17:17:56 GMT

I've got an existing SDE polygon layer that I'm looking to update the features in. The updated features are in a File GDB. My situation is such that the people who are responsible for the updates requested a script to do it.

The easiest way I can see doing this via a script (since we have to put it into multiple environments) was via the sdeimport -o init command, where features are deleted and then updated.

When I try to put my info in, I get a message saying the gdb layer.sdx file doesn't exist.

This is what I'm entering:

sdeimport -o init -l old_file,shape -f /home/me/my_test_tables.gdb/new_layer -v -i 4321 -s targetserver -u myuser -p mypass

And this is the result I'm getting:

ArcSDE 9.2 for Oracle10g Build 1271 Tue Jun 24 07:47:53 2008

SDEX File Import Administration Utility

-----------------------------------------------------

Export file /home/me/my_test_layer.gdb/new_layer.SDX does not exist.

Any help is appreciated.

Re: using sdeimport to update an existing SDE layer w/an updated FC

AsrujitSengupta — Wed, 19 Aug 2015 18:34:36 GMT

You can simply script this, using Delete Features tool and then using the Append tool.

The 'sdeimport -o init' command cannot update a layer in sde gdb with records from a layer in File gdb directl. To execute this command you need an SDE Export file to be present first.

Re: using sdeimport to update an existing SDE layer w/an updated FC

VinceAngelo — Thu, 20 Aug 2015 02:49:10 GMT

ArcGIS 9.2 has been retired for over three years now, and ArcSDE command line tools have not (and will not) ever supported file geodatabase. The task would be easy with a modern release of ArcGIS Desktop (with Python scripting), but it's been too long since I last used 9.2 to begin to say how difficult the task might be.

- V