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 |
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 |
Feature Support | IBM DB2 UDB | Microsoft | 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 |
Source Database | |
![]() | IBM DB2 ZSeries Z/OS |
![]() | IBM DB2 iSeries |
![]() | Informix IDS |
![]() | Postgres |
Source Database | |
![]() | Informix Dynamic Server 7.3, 9.1, 9.2, 9.3, 9.4 |
![]() | IBM DB2/400 V4R3 and V4R5 |
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 |