Oracle to DB2 Conversion Guide for Linux, UNIX, and Windows

An IBM Redbooks publication


Abstract

NOTE: There is a new conversion guide available for DB2 9.7 - Oracle to DB2 Conversion Guide: Compatibility Made Easy which can be found at: http://www.redbooks.ibm.com/abstracts/sg247736.html

IBM DB2 has long been known for its technology leadership. This IBM Redbooks publication, intended for technical staff who are involved in an Oracle to DB2 conversion project, is an informative guide that describes how to migrate the database system from Oracle to DB2 Version 9 on Linux, UNIX, and Microsoft Windows platforms.
This book provides conversion methodology and step-by-step instructions for installing and using IBM Migration Toolkit (MTK) to port the database objects and data from Oracle to DB2. It illustrates, with examples, how to convert the stored procedures, functions, and triggers. Application programming and conversion considerations are discussed, along with the differences in features and functionality of the two products.
In addition, you can find script conversion samples for data loading, database administration, and reports that are useful for DBAs. The testing section provides procedures and tips for conversion testing and database tuning. The laboratory examples are performed under Oracle 10g and DB2 Version 9. However, the migration process and examples can be applied to Oracle 7, 8, and 9i.

Table of contents

Chapter 1. Introduction
Chapter 2. Conversion methodology
Chapter 3. MTK
Chapter 4. Porting with MTK
Chapter 5. Conversion reference
Chapter 6. Data conversion
Chapter 7. Application conversion
Chapter 8. XML conversion
Chapter 9. Script conversion
Chapter 10. Testing
Chapter 11. Database administration and management
Appendix A. Data types
Appendix B. Terminology mapping
Appendix C. Function mapping
Appendix D. Oracle Call Interface (OCI) mapping
Appendix E. Converter for SQL*Loader
Appendix F. Example Oracle database
Appendix G. Additional material




Profile

Publish Date
09 August 2007


Rating:
(based on 3 reviews)


Author(s)

ISBN-10
0738489271

ISBN-13
9780738489278

IBM Form Number
SG24-7048-01

Number of pages
744