Porting spatial data (layers, spatial views) from SDE9.1 to SDE 10.1

GeorgeShi

Hi all,

We have SDE 9.1/Oracle 9i currently running on Solaris and plan to install a new geodatabase environment (SDE10.1/Oracle 11g).

I would like to get your suggestions on:
        porting schema and data content from source (SDE9.1) to destination (SDE10.1)

Any suggestions such as utilities and tools should be used, practical considerations are very much appreciated.



Thanks in advance!

George

WilliamCraft

There are probably many approaches you can take to achieve what you're wanting to do.  The complexity depends on your data model, in my opinion.  In general, I think the following options might work for you:

1. Create a new Oracle 11g database, use the Create Enterprise Geodatabase tool, use the Enable Enterprise Geodatabase tool, manually perform a copy/paste in ArcCatalog of all data (making sure to be connected using the correct schema owners for each object class).
3. Create a new Oracle 11g database, use the Create Enterprise Geodatabase tool, use the Enable Enterprise Geodatabase tool, connect to your Oracle 9i geodatabase using the 10.1 client (if it works) and export an XML schema file, connect to your new 10.1 geodatabase and import the XML schema document, use Simple Data Loader in ArcCatalog or Load Objects tool in ArcMap to bring your data in (has to be done per feature class and per table).
5. Create a new Oracle 11g database, use the Create Enterprise Geodatabase tool, use the Enable Enterprise Geodatabase tool, connect to your Oracle 9i geodatabase using the 10.1 client (if it works) and export an XML file with data option checked, connect to your new 10.1 geodatabase and import the XML file.
7. Upgrade your Oracle 9i database to an 11g database following upgrade documentation from Oracle, upgrade from 9.1 to a currently supported release (I think that's 10.0 now), use the 10.1 Upgrade Geodatabase tool to upgrade a second time to get it to a 10.1 GDB. 

There may be other paths to get where you need to go, but these paths pop out at me as the first ones to look at.  Some are better than others and some are more risky.  Your choice may depend on how much data you have, if you have a versioned GDB or not, if you have geometric networks or topologies or not, and how comfortable you are with Oracle upgrades.

Option 1 might be the most straight forward and the cleanest method.  Option 2 might not work if a 10.1 client can't connect to an older 9i database; not to mention it's tedious to load everything manually at separate times.  Option 3 might fail if you have too much data; XML files with data aren't always the most reliable method of data migration.  Option 4 could be terrifying; I've done a few Oracle upgrades and they are painful.  Equally as painful is the Upgrade Geodatabase tool... which won't actually tell you if the GDB will upgrade or not until it actually tries (the pre-req check doesn't behave well).  ArcSDE 9.x allows some geometry issues to persist in your data that 10.1 might otherwise complain about; the upgrade may fail and you'll be left holding the bag. 

Once you're done getting your data migrated or upgraded, you'll of course need to address things like permissions for users and roles.  The SDE user will need specific permissions too; upgrading tends to require more system permissions.  There is documentation about all of this on the ArcGIS Resource Center website. 

Caveat to all options listed or not listed: Take a good backup of your database first!