upgrade SQL to Oracle

vinnyl

Member
A customer running JDE Xe upd6 Win2000 SQL wants to "upgrade" the JDE database from SQL to Oracle9i.

I ve tryed the JDE way R98403 from one data source to a temp one
For example :
Control Tables - Prod points to SQL
Control Tables - Prod - Temp pints to Oracle on the same machine
After that we change the "Control Tables - Prod" to point to Oracle.


The problem is that copying all tables for all the environments will take days with R98403.
Do you know a procedure (Oracle, SQL safe tools) that we could use .

Thanks for your help
Vinnyl
 
H,

You should use the R98403 since it will do all the conversions for you without worrying about data issues.

I have used the R98403 many time to conversion from SQL to Oracle, Orale to SQL, Sql to AS/400 and AS/400 to SQL Server with no data issues.
 
Vinnyl :

You can create empty tables with R98403 and then copy data from SQL to
Oracle with DTS.

Sebastian
 
Hi Vinnyl

I believe Oracle has a tool (Oracle Migration Workbench) which will do the
migration from SQL to Oracle. We tried to use it a few years ago going from
SQL 6.5 to Oracle 8.0.5 but had problems with it wanting to put LOBs into
bitmap indexes. (I would suggest that the tool has developed somewhat since
then and will probably meet your needs). For us, in the end we used the
method you are currently using and it worked well. Remember that OneWorld is
fully configurable over both databases, so there is nothing to stop you
doing the migration in stages providing you have the hardware capabilities
to handle it. We did the migration over the period of about a month, doing
segments of data we could handle in a weekend. At the end of each segment we
just altered the datasources to reflect what data was where. It was totally
transparent to the users execpt for the downtime.

Regards

Marty Fleming
Business Analyst
Richmond Limited

Phone: +64 +6 8786464 Ext 8168
Fax : +64 +6 8780959
Mobile: +64 +21 478946
Email: mailto:[email protected]

OneWorld: Xe SP16.1
Database: Oracle 8.1.6.3
Enterprise Server: Compaq Proliant 8500R W2K





OneWorld: Xe SP16.1
Database: Oracle 8i
Enterprise Server: Compaq Proliant 8500R W2K
 
You might want to consider using UBE R98403B (included in recent Planner ESUs). This is an 'advanced' version of R98403 that performs bulk copy of records. I have not tried this UBE for big amount of data, so can't really say how big the performance is.

But there is some, definitely...

Unfortunately, as per JD Edwards, -
" Tables with BLOB data types (Central Objects) can be copied with R98403B but there is no performance improvement"
SAR 5780501.

I believe that this will work for SQL->Oracle conversion, but I have tried it only for Oracle->Oracle.

Yaroslav Mudrenko
CNC consultant
 
I am interested in knowing your results from any testing done with R98403B. I noticed that it recently appeared but have yet to have had the opportunity to try it out.
 
A great thank you to all of you for your support.
I will carry on this way (running R98403).
As I am not experienced enough with CNC do you what changes need do be applied once all data have been transfered. I mean I suppose JDE.INI on clients, Deployment srv, Enterprise srv and other things need to change. To run JDE with Oracle.

TA
Vinnyl
 
Back
Top