 | 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.
|
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.
|
|
|
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. | |
Products
Printer View