No se han encontrado resultados

Su búsqueda no coincide con ningún resultado.

Le sugerimos que pruebe lo siguiente para encontrar lo que busca:

  • Compruebe la ortografía de la búsqueda por palabras clave.
  • Utilice sinónimos de la palabra clave que escribió; por ejemplo, pruebe con “aplicación” en lugar de “software”.
  • Pruebe una de las búsquedas populares que se muestran a continuación.
  • Realice una nueva búsqueda.
Preguntas más populares
Migrate to Oracle Database with SQL Developer

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.

No matter what stage of the migration process you are in, SQL Developer can assist in your planning and migration execution. Learn more about Migration Planning and Methodology. Once you're ready to migrate, get started with SQL Developer and select the platform to migrate from.

Ready to Migrate?

White paper: Migrating to Oracle Database (PDF)

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:

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

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