Database Migration Path

This is the recommended database migration path to follow when using the services available from the Oracle Platform Migrations Group (PMG).

Follow the steps outlined below to perform your migration according to the recommended migration path. Please read through all steps as you will find useful links here for each phase of your migration project:

1 - Install and Set Up the Hardware for your Oracle Database 11g

Refer to the Oracle Database 11g documentation for detailed information about hardware requirements.

2 - Download and Install an Oracle Database 11g

Perform an Enterprise or Client database download depending on your requirements. You only need Oracle SQL Developer or an Oracle client installation for those machines that only need to access the Oracle Database 11g server instance. Download the Database software from here.

3 - Download and Install Oracle SQL Developer

Oracle SQL Developer Migrations
Use Oracle SQL Developer Migrations to migrate your non-Oracle database schema, including data, triggers, views, stored procedures, and other database objects to an Oracle database. The specifics of what is migrated depends on the database being migrated.

4 - Download Presentations and Documentation

Download the following presentations and documents to help you understand Oracle architecture, technical issues, the scope of the migration, and the recommended migration methodology:

  • Oracle Database 11g Product Family - Outlines the choices of Oracle Database editions available. Each edition of Oracle Database 11g has features and functionality to meet the varying requirements of today’s business applications.
  • High-Level Migration Presentation - Explains why to use Oracle and introduces the migration methodology, migration tools, typical migration timeframes, etc. (to be updated)
  • Technical Migration Presentation - Compares Oracle to other RDBMS products, highlights things to watch out for, and includes a Tips and Tricks presentation. (to be updated)

5 - Train your Staff

It is recommended that your staff refer to the following training materials to help them get started in an Oracle environment:

  • New to Oracle - An area on the Oracle Technology Network (OTN) Web site dedicated to technical folks who are new to Oracle.


6 - Download PTS Service Request Form

Download this document to sign up for the Migration Services for Partners offered by the Platform Migrations Group(PMG) in Oracle.

7 - Download Technical Migration Questionnaires

Download the appropriate Technical Migration Questionnaires from the following list so that an assessment/estimate can be completed for your migration project:

8 - Send Questionnaires to Oracle

Send the completed Service Request Form and the Technical Migration Questionnaire to the appropriate address (names on Migration Services Request Questionnaire document).

9 - Review Assessment, Scope, and Estimating Examples and Templates

Using the information you provided in the questionnaires, a PMG representative will create and send you an estimation document that includes an estimated timeframe for the migration project as well as the main steps required to complete the migration. In the meantime, you may find it useful to review the following documents:


10 - Start the Migration

Use the following tools and services to begin your migration:

11 - Use Migration Support Resources

If you run into any difficulties during your migration project, use the following resources to find solutions to your problems:

  • Discussion Forum - Subscribe to the forums and get hints and tips from migration experts.
  • Migration Knowledge Base - Check out the repository of common technical issues encountered during migration projects and find out how to perform particular technical tasks in Oracle. The Knowledge Base also includes sample "before and after" code and is updated on an ongoing basis.



If you still have questions or need assistance, please contact Tom Laszewski .

Collaborate 16

Oracle Database Cloud