• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2562
  • Last Modified:

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

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
matrix0511
Asked:
matrix0511
1 Solution
 
Gary PattersonVP Technology / Senior Consultant Commented:
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
 
matrix0511Author Commented:
Thanks Gary!
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now