Migration

55 pts.
Tags:
IBM iSeries
Migration from OS/400 to Oracle 10g
Oracle 10g
Oracle migration
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.

Answer Wiki

Thanks. We'll let you know when a new response is added.

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

Discuss This Question: 2  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • 7927
    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.
    55 pointsBadges:
    report
  • carlosdl
    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.
    69,510 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following