Solved

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

Posted on 2012-03-22
3
2,301 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 35

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

Three Reasons Why Backup is Strategic

Backup is strategic to your business because your data is strategic to your business. Without backup, your business will fail. This white paper explains why it is vital for you to design and immediately execute a backup strategy to protect 100 percent of your data.

Question has a verified solution.

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

Let's review the features of new SQL Server 2012 (Denali CTP3). It listed as below: PERCENT_RANK(): PERCENT_RANK() function will returns the percentage value of rank of the values among its group. PERCENT_RANK() function value always in be…
Ever wondered why sometimes your SQL Server is slow or unresponsive with connections spiking up but by the time you go in, all is well? The following article will show you how to install and configure a SQL job that will send you email alerts includ…
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

733 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