Solved

How To Migrate Databases From iSeries to SQL Server (Windows)?

Posted on 2012-03-22
3
2,211 Views
Last Modified: 2012-05-10
I have a project coming up to migrate an client from JD Edwards Oneworld running on iSeries to SQL Server Windows plateform.

I have only performed this task once and that was about 10 years ago.

So I wanted to try and contact some iSeries experts (like Gary) who have iSeries experience and also JD Edwards and any high-level steps for migrating off iSeries onto Windows. Or any documentation you could provide would be even better.

Once I migrate them onto Windows/SQL Server i will need to perform an upgrade from OneWorld to EnterpriseOne 9.0.

Thanks
John
0
Comment
Question by:matrix0511
3 Comments
 
LVL 37

Expert Comment

by:momi_sabag
ID: 37780505
0
 
LVL 34

Accepted Solution

by:
Gary Patterson earned 500 total points
ID: 37874058
John,

Specific JDE source/target version info would be good.

The guides that momi_sabag posted links to are generic DATABASE migration guides:  They are very usefule for moving a database wholesale from DB2 to SQL server and duplicating the structure on SQL server as closely as possible.  (Maybe for a data warehouse, or if you're porting an application or DB to Windows.)

That's not what I read as your project.  

You already have a target database, right: OneWorld on SQL Server?

If so , then you need to do an APPLICATION-SPECIFIC DB PLATFORM MIGRATION, moving the JDE database from one supported DB (AS/400 DB2) to another (SQL Server).

Here's a nice whitepaper that outlines a similar process for EnterpriseOne.  I don't know of a similar guide for OneWorld.  Maybe you could do the upgrade to EnterpriseOne first, and then do the DB migration.  Oracle might work with you on getting a temporary AS/400 EnterpriseOne license to use for conversion purposes.

http://download.microsoft.com/download/8/6/7/867A7D31-5AAA-4C09-9DD7-E802459A0696/migrating_from_iseries_to_sql_server.pdf

Might also be worthwhile to loop in your Oracle rep, and see if they don't have documentation or tools to assist with this kind of data move.

- Gary Patterson
0
 

Author Closing Comment

by:matrix0511
ID: 37952278
Thanks Gary!
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Nowadays, some of developer are too much worried about data. Who is using data, who is updating it etc. etc. Because, data is more costlier in term of money and information. So security of data is focusing concern in days. Lets' understand the Au…
For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties

911 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now