|
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 |
|
|
Y |
Y |
Y |
|
|
Y |
Y |
N |
|
|
Y |
Y |
Y |
|
|
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 |
|
|
|
Bookmark
