Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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?

share|improve this question
up vote 7 down vote accepted

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

share|improve this answer

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.

share|improve this answer
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 '14 at 8:53

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

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