ArcSDE long version transactions and ArcSDE Versions Upgrades

Discussion created by northpole on Jan 21, 2012
Greetings everyone,
Can anyone suggest what would be the best pattern to upgrade ArcSDE version while you are running long business data edits / transactions based on multilevel ArcSDE Versioning mechanism? These data update jobs sometimes are taking 2-3 years and are not coincident with one another. There is always a new version every year and we have to update in order to leverage the new features introduced in the full suite of software.

The update was possible using Oracle import tools till ArcSDE 9.3.1 version but with ArcGIS 10 system tables for ArcSDE are changed and now there is no existing documentation on any migration procedure from ArcSDE 9.3.1 data model / system tables to ArcSDE 10 data model.

Can anyone suggest what should be the possible solution or if there is any practical versioning workflow we can adopt to accomplish this?

Thanks to you all for your time and support in advance.