Oracle SQL Developer Migrations: Supported Platforms

 

Date: August 2014

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: Migration Support


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

 

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

 

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