Skip to main content

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.

thumbnail 

Published on 03 July 2009, updated 07 July 2009

  1. .PDF (6.4 MB)


Share this page:   

ISBN-10: 0738433020
ISBN-13: 9780738433028
IBM Form #: SG24-7730-00


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

    menu icon

    Abstract

    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