Oracle Migration Workbench
Release 10.1.0.4.0
Left Curve
Return to...
Right Curve
 ·
 ·
 ·

The Oracle Migration Workbench, originally a tool for simplifying the process of migration from a range of non-Oracle databases to Oracle, has now entered a desupport cycle, while the existing functionality has been incorporated into Oracle SQL Developer.

Important Use Oracle SQL Developer Migrations to migrate Microsoft Access, Microsoft SQL Server, MySQL and Sybase databases to Oracle Database. Support for DB2 migration is scheduled for Oracle SQL Developer 2.0, with support for Informix to follow in a release after that.

Oracle Migration Workbench 10.1.0.4.0 is available for migrating Informix and DB2 databases to the Oracle platform (Oracle9i, Oracle10g and Oracle11g), specifically:

Source Database
Supported Platform

Informix Dynamic Server 7.3, 9.1, 9.2, 9.3, 9.4

Windows, Linux

IBM DB2/400 V4R3 & V4R5

Windows
IBM DB2 UDB V6, V7.1, & V7.2 (Beta)
Windows

Enhancements and Features

  • Informix plug-ins: Collection data types and sequences supported.

Check the Release Notes for a complete list of new features before you download the software. Visit the Oracle Migration Knowledge Base to gain access to technical articles provided by Oracle migration experts.

Note: For migrations from other databases not listed in the above table, check out the Migration Solutions Directory.

Core Features

Migrates a range of third-party databases to the Oracle platform.
Stores information about the structure of the production databases 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 and Pro*C.
Provides advanced customization capabilities such as the ability to change data type mappings, and 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 SQL*Loader scripts for data movement.
Allows you to select existing tablespaces in the destination Oracle database to which objects can be migrated.
Displays informational, error, and warning messages about the migration in the Progress window.
Resolves object name conflicts, such as conflicts with Oracle reserved words, automatically.

Supported Features

Feature Support
Informix
DB2/400
DB2/UDB

Tables

Y
Y
Y

Views

Y
Y
N

Indexes

Y
Y
Y

Groups/Roles

Y
N
Y
Users
Y
Y
Y
Constraints
Y
Y
Y
Privileges
Y
Y
Y
User-defined Types
N/A
Y
Y
Stored Procedures
Y
N
N
Triggers
Y
N
N
Embedded SQL
ESQL/C to Pro*C
N
N/A
Other features
Collection data types, sequences.
N/A
Schema objects migrated to User objects
E-mail this page
Printer View Printer View
Oracle Is The Information Company About Oracle | Oracle RSS Feeds | Careers | Contact Us | Site Maps | Legal Notices | Terms of Use | Privacy