UPGRADE JDE OneWorld 7.3.2 database (SQL Server 7.0 to 2000 or more)

[Amper]

We have a server running Windows NT 4.0 with JDE OneWorld 7.3.2 and SQL Server 7.0 all in one server (production) and a second server (deployment). We want to upgrade the database to a new server (separate from the application) and install SQl Server 2000 or 2005 with Windows Server 2003. How dificult is this? Is this possible? If so, how much time would it take? If someone has experience on this we are open to hiring a consultant.

 

[klwong]

Depending on when you did your installation, exactly what sub-version (B73.2 base, B73.2.1, B73.2.2) you are running, and what Service Pack, you might be able to get to SQL Server 2000. SQL Server 2005 is pretty much out of the question because the ODBC drivers are different.

Separating your database server and having a different application server is not a big deal. You can do that with the software you already posses.

However, your biggest problem is that no matter what you do, you will not be supported as all of those platforms have long since expired.

I suspect that you are no longer on maintenance with Oracle. If you are, then any move of this magnitude will probably have Oracle insisting that you upgrade OneWorld to something more recent. Only then would you be able to get official support for Windows 2003 and SQL Server 2005.

Dusting off the old memories, I seem to recall that an upgrade from the B73.2.x family up to the B73.3.x family (Xe or ERP8) required a lot of little workarounds which the manual didn't address. I'm a pack rat, so I may actually have the stuff put away in a box somewhere, but the Good Lord only knows how many other people in the country remember what this kind of upgrade entailed.

 

[altquark]

This isn't impossible (!). It all depends on what your expectations are - are you also upgrading from B732 to, say, 9.0 and are you expecting a functional change ?

I performed a large number of B733 base (pre B7331) upgrades to Xe - and I believe I performed some of the very first B732x upgrades to B733 and B7331 - there are significant architecture changes through those releases - and I have a methodology that would actually upgrade you to a current version in a safe, short period of time.

Its late right now, and I'd be open to discuss your strategy offline - if you're interested, shoot me a mail or a personal message directly...