Keine Ergebnisse gefunden
Ihre Suche ergab keine Treffer
We suggest you try the following to help find what you're looking for:
- Check the spelling of your keyword search.
- Use synonyms for the keyword you typed, for example, try “application” instead of “software.”
- Try one of the popular searches shown below.
- Start a new search.
Trending Questions
Migrate to Oracle Database with SQL Developer
Oracle offers a wide range of migration services to help you optimize your usage of Oracle technology. Through the use of tools, resources, and proven best practices, Oracle can provide support for migrating from legacy or non-Oracle technologies to Oracle. Oracle SQL Developer is Oracle's Migration tool to migrate non-Oracle databases to Oracle. Migrating with Oracle SQL Developer reduces the time, risks, and financial barriers involved in migrating to the Oracle platform.
Ready to Migrate?
White paper: Migrating to Oracle Database (PDF)
Video: Oracle SQL Developer: Online Migration 3.1 (10:00)
Video: How to Migrate SQL Server Database to Oracle Using SQL Developer (5:53)
Hear What Customers Have to Say
“The Database Migration tool in SQL Developer gave us a powerful yet simple mechanism to consolidate data from disparate systems into a centralized Oracle database. We love the SQL Developer Database Migration Tool. The menu driven process made our migration from MS SQL to Oracle a snap. With the Database Migration Tool built into SQL Developer, we were able to quickly consolidate data from several non-oracle databases into one Oracle database, simplifying reporting and eliminating the need for dblinks.”
—Danny Bryant, IT Manager at City of Atlanta
Read about Danny’s Success Story of migrating MS SQL Server to Oracle Database using Oracle SQL Developer (PDF)
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:
- Oracle SQL Developer 4.0 supports migration from IBM DB2, Microsoft Access, Microsoft SQL Server, MySQL, Sybase and Teradata databases to Oracle Database
- Oracle Migration Workbench 10.1.0.4.0 is available for migrating Informix and other DB2 databases to Oracle Database
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 |