Home > IT Answers > AS/400 > Migration
7927
55 pts.
 Migration
iSeries, Migration from OS/400 to Oracle 10g, Oracle 10g, Oracle Migration Workbench, OS/400, OS/400 and iSeries, V5R3, V5R3MO
I like to migrate a database which is in IBM OS/400 V5R3MO (Source)using iseries navigator to Oracle 10g.In the source database there are few stored procedures and few triggers which I like to migrate from source to oracle too. So I like to know is Oracle migration workbench will able to do so or is there any other tools will do or any other way.please recommend. The requirement is very urgent and I will appreciate your thoughts.

Software/Hardware used:
ASKED: November 25, 2008  10:58 PM
UPDATED: November 26, 2008  4:12 PM
RELATED QUESTIONS
Answer Wiki:
From the documentation, these are the supported Third-party Databases: <i>Use Migration Workbench for Windows to migrate the following third-party databases to an Oracle Database 10g or Oracle9i database: ■ IBM DB2/400 V4R3 and V4R5 ■ IBM DB2 UDB 6, 7.1, and 7.2 ■ Informix Dynamic Server 7.3 ■ Informix Dynamic Server 9.x ■ Microsoft Access 2.0, 95, 97, 2000, XP (2002), and 2003 This release of Migration Workbench also allows you to migrate a Microsoft Access database to an Oracle Lite database. ■ Microsoft SQL Server 6.5, 7.0, and 2000 ■ MySQL 3.22, 3.23, and 4.x ■ Sybase Adaptive Server 11 and 12 Use Migration Workbench for Linux x86 to migrate the following third-party databases to an Oracle Database 10g or Oracle9i database: ■ Informix Dynamic Server 7.3 ■ Informix Dynamic Server 9.x ■ MySQL 3.22, 3.23, and 4.x ■ Sybase Adaptive Server 11 and 12</i> Oracle says that Workbench migrates the entire database schema, including triggers and stored procedures, but it seems that not all features are supported for all databases. I would recommend to contact Oracle Support, since database migration is a very delicate task.1
Last Wiki Answer Submitted:  November 26, 2008  2:03 pm  by  carlosdl   63,535 pts.
All Answer Wiki Contributors:  carlosdl   63,535 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

thanks Carlosdl
but oracle workbench dont work with IBM OS/400 V5R3MO as it is not v4r5 or v4 r3 .
is there any other tools or and other way.

if i do it manually how to do it by using i series navigator.

please help me…

and sorry i pressed the wrong button for your rating.

7927
 55 pts.
 

Don’t worry about the rating :-)
I have never worked with i series navigator, so I cannot help you with that, but in general, you would need to export the data from your OS/400 (to text files for example), create your database structure and import the data into Oracle (using Sql*Loader for example), but that would not include triggers or stored procedures.

carlosdl
 63,535 pts.