Migration
Home > IT Answers > AS/400 > Migration
7927
55 pts.
0
Q:
Migration
OS/400, iSeries, OS/400 and iSeries, V5R3, Oracle 10g, Oracle Migration Workbench, V5R3MO, Migration from OS/400 to Oracle 10g
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.
ASKED: Nov 25 2008  10:58 PM GMT
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
RELATED QUESTIONS
0
7927
55 pts.
0
A:
 RATE THIS ANSWER
-1
Click to Vote:
  •   1
  •  -2
  • AddThis Social Bookmark Button
From the documentation, these are the supported Third-party Databases:

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

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 Answered: Nov 26 2008  2:03 PM GMT by 7927   55 pts.
Latest Contributors: Carlosdl   29855 pts.
  •   
0
0
RSS - Discussions Help
Discuss This Answer:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _



_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

7927   55 pts.  |   Nov 26 2008  2:09PM GMT

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.

 

Carlosdl   29855 pts.  |   Nov 26 2008  4:12PM GMT

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.

 
0