I'm using ArcGIS Server 10.0, ArcSDE 10.0 and Oracle 11g.

I'd like to create a sde export of my layers' schema. The export would be used to create easily those layer in a new database instance.

Do you know of an export/import SDE command that allows that?

Or at least, is it possible to import an XML schema file using a SDE command or Python script?

2 Answers 2


At 10.1 they added geoprocessing tools to import/export XML workspace documents. At 10.0 you'd need to write something (see these: 1, 2) using ArcObjects, use Delete Rows beforehand, or use a more complex combination of geoprocessing tools and logic in Python (e.g. what X-Ray for ArcCatalog does).


The 'sdeexport' command accepts a WHERE clause flag (-w). Just set it to 1=0, and the resulting export file will be empty.

Note that an 'sdeimport' of the resulting file will not have any ArcGIS metadata, or ArcGIS anything (feature datasets, domains,...), so you really don't want to do this unless you have a bunch of simple feature classes created with command-line tools and barely registered with the geodatabase.

  • In my case, all exported tables are "registered with geodatabase" feature classes with a spatial index and an attribute index on the OBJECTID field. Constraints (FK, NULLABLE, ...) are created with SQL scripts. Do you think the sdeexport is adequate in this case? What ArcGIS metadata are you talking about?
    – yo_haha
    Jan 6, 2014 at 8:53

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.