Solved

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

Posted on 2012-03-22
3
2,360 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
3 Comments
 
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

Raise the IQ of Your IT Alerts

From IT major incidents to manufacturing line slowdowns, every business process generates insights that need to reach the people required to take action. You need a platform that integrates with your business tools to create fully enabled DevOps toolchains.

You need xMatters.

Question has a verified solution.

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

Introduction In my previous article (http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SSIS/A_9150-Loading-XML-Using-SSIS.html) I showed you how the XML Source component can be used to load XML files into a SQL Server database, us…
For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
Via a live example, show how to setup several different housekeeping processes for a SQL Server.

696 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