Oracle to DB2 UDB Conversion Guide2003

Overview

In this chapter we discuss and demonstrate the conversion of database objects, and the extraction and loading of data into a DB2 UDB database using the IBM DB2 Migration Toolkit (MTK).

The following items are discussed:

• Preparation for porting

• Running MTK

• Extracting or Importing metadata into MTK

• The Convert task

• The Refine task

• The Generate Data Transfer Scripts task

• Deploy to DB2 considerations

• Next steps

• Converting the remaining objects

• Deployment of stored procedures, functions, packages, and triggers

• MTK conversion conclusion