We have a prod database, with an SDE schema. We want to install a new SDE instance 9.3.1 and link it to a copy of the prod database.

ArcSDE 9.3.1 on Linux SLES 4

Now, what is the best way to do this. It isn't an upgrade, so you can't really upgrade the SDE install I think? If you simply install the SDE on top of a pre-existing SDE schema, there are all sorts of links broken, indexes, data issues, etc.

So, if I am correct, then is the only way to go, is to build an empty database (save from the users table) and then import all of the data via sdeimport (obviously using the date from a sdeexport)?

I am not normally involved with SDE, preferring to leave it with those mystical creatures, the DBA's, but I can't find one here (I believe they Apparate and Disapparate without control) so have no option but to do this myself, and find myself without the 100% self belief it is the right way to go.

Any ideas?


We have no way of accessing the original data live, so have to export the Oracle data from one area to another, before we can access it e.g. we cannot simply access the live data 'live' as such.


Backup your database first [most important]


and there is 9.3.1 version

Migrating Oracle data from one storage type to another



  • full oracle export from SDE 9.x
  • full oracle import into SDE 9.3.1
  • upgrade SDE software from 9.x to 9.3.1
  • upgrade to high precision
  • then apply the update to the storage types
  • This is all 9.3.1 so using arcpy isn't an option. – Hairy Jan 20 '12 at 8:52
  • Hairy the bottom link is for 9.3 and the topic was updated for 9.3.1 "This topic was updated for 9.3.1." Though this can be done outside of ArcGIS if you have very good Oracle SQL skills and knowledge of the SDE structure. – Mapperz Jan 20 '12 at 14:59
  • My main problem, though, Mapperz, is that it's not a straightforward bit of work, as it involves DB dumps, and everything. What I am doing at the moment, is exporting the data from live, with an sdeexport, then importing it using sdeimport. This works fine, but is slightly long winded. However, my great issue comes with a fresh 11g box, migrating the 9i database, then doing the same with sde 9 to 9.3.1. Bit of a pain really and I dont have any live access to the live data! Thanks for your advice. – Hairy Jan 20 '12 at 16:21
  • I think this is about as good as we could hope for. Thanks. – Hairy Jan 20 '12 at 22:24

You can use your ArcCatalog for the export of ArcSDE Database in XML.

ArcCatalog export your workspace XML

And you can export your data and architecture in XML. After, you create your ArcSDE database and upload your XML.

Good luck.

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.