Ask the Expert

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). 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?

    Requires Free Membership to View

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

There are Comments. Add yours.

 
TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

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
Sort by: OldestNewest

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: