By submitting your personal information, you agree that TechTarget and its partners may contact you regarding relevant content, products and special offers.
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
, 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.