Oracle to DB2 UDB Conversion Guide2003

4.8 Next steps

We have just completed the first part of our migration, i.e., converting all of the objects upon which the other objects (stored procedures, functions, packages, and triggers) depend. Based on information from the Verification report, we can declare success since all of the tables, views, and sequence objects from the original Oracle database were converted, and more importantly, were deployed correctly into DB2 UBD. We can also see that the data was extracted from Oracle, and that the same number of rows were loaded into DB2. We are now ready to begin the process of converting the stored procedures, functions, packages, and triggers.

Strategy

The strategy for the remainder of the project is:

• Convert the remaining objects

• Examine and evaluate the messages from the translator

• Deploy the remaining objects into DB2

• Manually convert objects that are not automatically converted by MTK