topic Migrate Versioned and Archived Data - Issue in Data Management Questions

Migrate Versioned and Archived Data - Issue

User35489 — Wed, 12 Jun 2013 11:04:25 GMT

Dear Gurus,

Can you please let me know how to migrate feature class(s) which is/are registered as version and archiving is enabled on it
From: Database Environment: RHEL 5, Oracle 11.2.0.2, ArcSDE 9.3, SDEBINARY
To Database Environment: RHEL 6, Oracle 11.2.0.3.0, ArcSDE 10.1, ST_Geometry

I used import feature class tool and copy tool to migrate these feature classes, but they succeded only in feature class data and no versioned/archiving stuff was found in destination database.

Please let me know the best practice for this....

Best Regards
Abdullah Saleh

Re: Migrate Versioned and Archived Data - Issue

KimPeter — Wed, 12 Jun 2013 20:06:49 GMT

You can migrate storage on the feature classes in place using the Migrate Storage toolhttp://resources.arcgis.com/en/help/main/10.1/index.html#//00170000000q000000, but not between databases.

I'm not aware of any way to move and migrate versioned data at the same time. Copying/pasting or exporting data will not take the versions and archives along with it.

Moving the entire database is the only way I can think of to preserve the versions and archives. Could you use a backup of the RHEL 5/Oracle 11.2.0.2/ArcSDE 9.3 database and restore it to RHEL 6/Oracle 11.2.0.3.0? Or use some other Oracle tool to move the contents of the entire database from one Oracle instance to another? If so, you could then upgrade the geodatabase to 10.1 and migrate the feature class geometry storage to ST_Geometry on the newer Oracle instance.

Re: Migrate Versioned and Archived Data - Issue

EmadAl-Mousa — Wed, 19 Jun 2013 05:52:24 GMT

you can take oracle dump file (export) from Database (A) , you need to take two schemas of course (SDE + the schema of your versioned feature classes). Then, Import the Dump to Database (B).