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 - Supported Databases
- Supported Features
- 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 - Supported Database and Platform
- 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 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 |
Developer Tools
Printer View