In this IBM® Redbooks® publication, we discuss considerations, and describe a methodology, for migrating from Oracle® 10g to the Informix® Dynamic Server (IDS). We focus primarily on the basic topic areas of data, applications, and administration, providing information about the differences in features and functionality in areas such as data types, DML, DDL, and Stored Procedures.

Understanding the features and functionality of the two products will better enable your decisions as you develop your migration plan.

We provide a migration methodology and discuss the processes for installing and using the IBM Migration Toolkit (MTK) to migrate the database objects and data from Oracle to IDS. We also illustrate, with examples, how to convert stored procedures, functions, and triggers. Application programming and conversion considerations are also discussed. The laboratory examples are performed under Oracle 10g and IDS Version 11.5. However, the processes and examples can also be applied to Oracle 7, 8, and 9i.

With this information, you can gather and document your conversion requirements, develop your required migration methodology, and then plan and excute the migration activities in an orderly and cost effective manner.

Chapter 1. Introduction

Chapter 2. Architectural overview

Chapter 3. Migration methodology

Chapter 4. IBM Migration Tool Kit: An introduction

Chapter 5. An MTK tutorial

Chapter 6. SQL considerations

Chapter 7. Data conversion

Chapter 8. Application conversion

Chapter 9. Administration of Informix Dynamic Server

Appendix A. Data types

Appendix B. Terminology mapping

Appendix C. Function mapping

Appendix D. Database server monitoring

Appendix E. Database server utilities

Appendix F. Additional material