Migrating from Oracle . . . to IBM Informix Dynamic Server on Linux, Unix, and Windows

An IBM Redbooks publication

Note: This is publication is now archived. For reference only.

Published 02 July 2009, updated 06 July 2009

cover image

ISBN-10: 0738433020
ISBN-13: 9780738433028
IBM Form #: SG24-7730-00
(398 pages)

More options

Rate and comment

Authors: Chuck Ballard, Holger Kirstein, Srinivasrao Madiraju, Sreeni Paidi, Nora Sokolof, Renato Spironelli


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.

Table of contents

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

Follow IBM Redbooks

Follow IBM Redbooks