Installing Oracle Instant Client Basic and Basic Light

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.

Download Oracle SQL Developer

Set up a Migration Repository

The Migrations Repository is a database schema that stores the meta_data collected and transformed in the migration process.


How to Create a Migration Repository

Configuring the Third Party Database Connection

You now need to configure a database connection for the database which you would like to migrate. There are two steps to this process:

Capturing Source Database

This step is used to capture a snapshot of the current state of your third-party database and is necessary to provide SQL Developer with a "point in time" view of your database. Once this step is complete, the Migration wizard works on the meta-data stored in its repository, instead of issuing queries against your live database.


Convert Captured Model to Oracle

The next step in the migration process is to convert the captured model of the database to an Oracle-specific model. The captured model contains data types, naming schemes etc. defined by your database vendor; this now must be converted to Oracle formats. Once the migration has completed, you can return the Captured Database Objects node and rerun the wizard from this point to convert some or all of the objects again.


Translate Third Party SQL Objects to Oracle

The next step in the migration process is to translate the T-SQL objects - constraints, functions, procedures, triggers, views - to Oracle SQL objects. Once the migration has completed, you can return the Converted Database Objects node and rerun the Migration wizard to translate some or all of the objects again.


Generating Scripts to Create Target Database

Once the conversion process has completed, SQL Developer has a model of what the converted database will look like. This is used to generate SQL scripts for the creation of the new Oracle Database schema(s) and to run these scripts.


Move Data from Third Party Database to Oracle

The last step in the Migration Wizard is to move the data to the new database. Migrating the data is a process that copies the data from the third-party database to the new tables in the Oracle database. The Migration Wizard uses the same Oracle database connection required to run the scripts as it does to move the data.


Migrating from DB2 to Oracle

Oracle SQL Developer is a free and fully supported product that provides tools and utilities to migrate from DB2 to Oracle.

Benefits of Consolidating Databases

Reduce Costs with Hardware and Software Consolidation and Improve Reliability, Scalability, and Peformance with Oracle.

How to Migrate with SQL


See this Quick Video on How to Migrate with SQL Developer

Learn more about DB2 Migrations