The Oracle Migration Workbench is a tool that simplifies
the process of migrating third-party database systems to the Oracle platform
(Oracle9i and
Oracle10g).
The Oracle Migration Workbench migrates the entire database schema, including
triggers and stored procedures, in an integrated environment.
This release of the Oracle Migration
Workbench includes several features and enhancements to facilitate your
migrations from the following databases:
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 now supported. The procedural language parser has also
been updated to cater for the migration of these additional objects.
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.