Migrate Versioned and Archived Data - Issue

[User35489]

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

[KimPeter]

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.

[EmadAl-Mousa]

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