Oracle SQL Developer Migrations: Supported Platforms

 

Date: March 2011

Oracle supports in the migration of database objects and data from a variety of databases to the Oracle database. Most of this migration offering is available from within Oracle SQL Developer, with a few legacy databases still handled by the original Oracle Migration Workbench. This document shows the databases supported and the tool used for this support. For further details please refer to the relevant OTN pages:

1. Oracle SQL Developer 3.0 - Migration Support for migrating from IBM DB2, Microsoft Access, Microsoft SQL Server, MySQL, Sybase and Teradata databases to Oracle Database

  1. Supported Databases
  2. Supported Features
  3. Scheduled for future release

2. Oracle Migration Workbench 10.1.0.4.0 is available for migrating Informix and other DB2 databases to Oracle Database

  1. Supported Database and Platform
  2. Supported Features

1. Oracle SQL Developer: Migration Support

1.1 Supported Databases

Source Database
 Microsoft SQL Server 7.0, 2000, 2005, 2008 R1 and 2008 R2
 Microsoft Access 97, 2000, 2002, 2003, 2007
 MySQL 3.x, 4.x, 5.x
 Sybase Adaptive Server 12, Sybase 15
 IBM DB2 LUW 8.x, 9.x
 Teradata 12, 13

 

1.2 Supported Features

Feature Support
IBM
DB2 UDB

Microsoft
Access

Microsoft
SQL Server
MySQL
Sybase
Teradata
Tables
Yes
Yes
Yes
Yes
Yes
Yes
Views
Yes
Yes (Queries)
Yes
No
Yes
No (Browse only)
Indexes
Yes
Yes
Yes
Yes
Yes
Yes
Groups/Roles
No
No
Yes
Yes
Yes
No
Users
Yes
Yes
Yes
Yes
Yes
Yes
Constraints
Yes
Yes
Yes
Yes
Yes
Yes
Privileges
No
No
Yes
Yes
Yes
No
User-defined Types
No
No
Yes
Yes
Yes
No
Stored Procedures
No
No
Yes
No
Yes
No
Triggers
No
No
Yes
No
Yes
No
Embedded SQL
No
No
No
No
No
No

1.3 Scheduled for future release

Source Database
 IBM DB2 ZSeries Z/OS
 IBM DB2 iSeries
 Informix IDS
 Postgres

 

2. Oracle Migration Workbench 10.1.0.4.0.

 

Supported Database and Platform

Source Database
 Informix Dynamic Server 7.3, 9.1, 9.2, 9.3, 9.4
 IBM DB2/400 V4R3 and V4R5

 

Supported Features

Feature Support
Informix
DB2/400
Tables
Yes
Yes
Views
Yes
Yes
Indexes
Yes
Yes
Groups/Roles
Yes
N
Users
Yes
Yes
Constraints
Yes
Yes
Privileges
Yes
Yes
User-defined Types
N/A
Yes
Stored Procedures
Yes
N
Triggers
Yes
N
Embedded SQL
ESQL/C to Pro*C
N
Other features
Collection data types, sequences.
N/A

 

March 2011