Q

Easy way to migrate from IBM DB2 to newer Oracle database

I've got an OS/2 Warp 4 Server with IBM DB2 version 2.0 (very old, I know) and Token Ring protocol at work, which I intend to migrate to a newer OS and database (with Ethernet). Are there any easy ways to convert a database as old as DB2 v2.0 to a newer Oracle db without turning my whole company upside down?

I've got an OS/2 Warp 4 Server with IBM DB2 version 2.0 (very old, I know) and Token Ring protocol at work, which I intend to migrate to a newer OS and database (with Ethernet). We are using Oracle Database at my company. Now to my question: Are there any easy ways to convert a database as old as DB2 v2.0 to a newer Oracle db without turning my whole company upside down?
Any time you go from one vendor's RDMBS to another vendor's RDBMS (e.g., from IBM's DB2 to Oracle), there will be lots of work involved. Oracle does have a Migration Toolkit on Technet, but it may not work with DB2 v2.0. So you'll have to do things manually. The first thing to do is to move the data. DB2 should have a utility to dump the table's contents to a text file. You can then use Oracle's SQL*Loader utility to load the contents of the text files into an Oracle database. Next, you'll want to re-create any views, triggers, stored procedures and functions in the Oracle database. This will require you to be well-versed in the language DB2 uses for its procedural compenents as well as Oracle's PL/SQL.
This was first published in November 2005

Dig deeper on Oracle database design and architecture

Pro+

Features

Enjoy the benefits of Pro+ membership, learn more and join.

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

0 comments

Oldest 

Forgot Password?

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

Your password has been sent to:

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide

SearchDataCenter

SearchContentManagement

SearchFinancialApplications

Close