What You See Is What You Get Element
Informix

Migrating from Informix to Oracle

Oracle Migration Workbench is a free product that provides the capabilities of migrating from Informix to Oracle. Whether you plan and complete the migration on your own or with the help of Oracle partners, review the following for more information.

Supported Migration Platforms

  • Source Databases: Informix Dynamic Server: 7.3, 9.1, 9.2, 9.3, 9.4
  • Oracle Databases: Oracle Database 9i and 10g
 

Content List

 Getting Started on a Migration
 FacebookTwitterYouTube
 Supported Migration Objects
 Informix Core Features
 Demonstrations and Tutorials
 Documentation
 Getting Help
 Learn More

Getting Started on a Migration

 Download Oracle Migration Workbench 10.1.0.4.0
   

Supported Migration Objects

 Tables  
 Constraints
 Indexes
 Users
 Views
 Groups/Roles
 Privileges
 Stored Procedures
 Triggers
 Embedded SQL (ESQL/C to Pro*C)
 Collection data types
 Sequences
   

Informix Core Features

Oracle Migration Workbench supports the following core features when migrating from Informix:

  • Stores database metadata in a repository where you can make changes.
  • Retrieves source database information via online capture or offline capture.
  • Parses and transforms stored procedures, triggers, and views to Oracle PL/SQL.
  • Provides advanced customization capabilities such as the ability to change data type mappings, delete and rename objects.
  • Generates reports about the status of the migration.
  • Generates the DDL scripts for the creation of the destination Oracle database.
  • Generates scripts for data movement.
  • Allows you to migrate objects to existing Oracle tablespaces.
  • Displays informational, error, and warning messages about the migration in a progress window.
  • Resolves object name conflicts, such as conflicts with Oracle reserved words, automatically.

Demonstrations and Tutorials

 Oracle Migration Workbench Quick Tour  
 Capture source database using offline capture scripts (example uses SQL Server)
   

Documentation

 Oracle Migration Workbench User's Guide (Release 10.1.0.4)
 Oracle Migration Workbench Guides (Release 10.1.0)
 FAQ on Migrating from Informix
   

Getting Help

If you don't want to attempt the migration on your own or you have more questions the following resources are available:

Learn More

 Planning a Migration
  • Download PMG Service Request Form
    • Work with our Platform Migrations Group(PMG) who can help you plan your migration or who will suggest partners to do the same.
    • Download this document to sign up for the Migration Services for Partners offered by the Platform Migrations Group(PMG) in Oracle
  • Review Assessment, Scope, and Estimating Examples and Templates
    • Using the information you provided in the questionnaire, a PTS representative will create and send you an estimation document that includes an estimated timeframe for the migration project as well as the main steps required to complete the migration.In the meantime, you may find it useful to review the following documents:
 Migration Methodology Roles and Responsibilities - Explains the migration phases and the activities and resources relevant to each phase.
 Training recommendations document - Explains the recommended training for a DBA who is new to Oracle.
 New to Oracle - An area on the Oracle Technology Network (OTN) Web site dedicated anyone new to Oracle.
 
Left Curve
Popular Downloads
Right Curve
Untitled Document
Left Curve
More Database Downloads
Right Curve