XE to 9.1 data only upgrade CNC effort estimate

Zaki Ahmed

Well Known Member
JDE upgrade question: If a customer wants to stand up a new 9.1 environment from their XE Production data as a sandbox for their users to see and learn new JDE 9.1, how much effort would it take provided all hardware MTR is fulfilled and no retrofitting is required? Consider this as a data only upgrade or technical upgrade.
 
JDE upgrade question: If a customer wants to stand up a new 9.1 environment from their XE Production data as a sandbox for their users to see and learn new JDE 9.1, how much effort would it take provided all hardware MTR is fulfilled and no retrofitting is required? Consider this as a data only upgrade or technical upgrade.

If you want to upgrade only the busineess data then Data only Upgrade will be the good option for you !


Data Only Upgrade
===============


A Data Only Upgrade is an abbreviated upgrade method that can be used if the customer has made no software modifications that need to be brought forward to the new release of the software.
In this method, only customer business data is preserved, and all other changes that might have been made to the software are overwritten.
Basically,the process is a new installation of the software for everything except the business data. The business data is then converted to the new release by running table conversions on this data source only.


In this abbreviated method, you can skip many of the tasks required for a normal upgrade. In some cases, you might need to slightly modify normal upgrade tasks as well.
For the data-only upgrade, the term business data refers to application tables only. Changes to control tables, such as user-defined codes (UDCs), menus, and data dictionary are merged, and additions to the Object Librarian are
populated when you run the Environment Workbench. However, changes to the specification tables (including Versions List) are not merged into the new release. Custom or modified tables, business functions, and applications are also not preserved in this process.


For more information refer E1: UPG: UPGTC: Information On Performing And Troubleshooting A Data Only Upgrade (Doc ID 1348415.1)
 
This really depends on the amount of data you have. Since you are moving from XE to 9.2 / 9.1; you will need to perform unicode conversion; which is recommended.
The time taken for data conversion depends on the amount of data, the machine involved and ofcourse the integrity of data. If I hazard a guess from the recent upgrades I have done for a mid level data set size, 12 hours plus the time for unicode conversions, which can be parallelized.
 
Stand up new 9.2 environment Fix Current, together with conversion of Xe to 9.2 data - data only. ~120-160 hours. Can be done on AWS easily, with approximately $1000 per month AWS charges.
 
Back
Top