Migration of Database

SandeepGhansela — Mon, 20 Sep 2010 07:27:40 GMT

Hi,
We are migrating our existing Geodatabase in oracle 9i running ARCSDE 8.3 to new 11gR2 database running ARCSDE 9.3.1,we have same schema for spatial and non spatial data.In our new database we want to keep spatial and non spatial data seperately in different schema.What should be the best approch to migrate ?

Regards,

Re: Migration of Database

VinceAngelo — Mon, 20 Sep 2010 13:07:36 GMT

I regularly partition data by schema to manage access, but never do solely on the basis of
spatial/non-spatial (I'm not sure if I really accept that there *is* non-spatial data, vice explicit
and implicit spatial data).

An ArcSDE 8.3 -> 9.3.1 "upgrade" isn't really possible (without several intermediate steps),
and 9i and 11g are sufficiently different that a fresh reload is likely your best migration path.
If you have versioned tables, preserving the versions during migration will be quite challenging.
The same goes with complex geodatabase behaviors and, to some extent, rasters.

If you have all simple non-versioned vector featureclasses at 8.3, then 'sdeexport' is your easiest
transfer methodology (you'll need to read up on storage method options for 'sdeimport', since
SDEBINARY is not available on 11g platforms). All other transfers would require more input
(including which versions of ArcGIS you have available to support incremental upgrades
via personal geodatabases).

You might be jumping the gun on 11gR2 support at 9.3.1 (10.0 is certified with R2 on more
platforms than 9.3.1), so you probably want to make sure it will work with 9.3.1 on your
platform before you proceed.

- V

topic Migration of Database in Data Management Questions

Migration of Database

Re: Migration of Database