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