Ihre Suche ergab keine Treffer.
Beachten Sie die folgenden Tipps, um das Gesuchte zu finden:
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.
“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:
Source Database
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 |
Source Database
Source Database
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 |