Migrating data from a MySQL database to an Oracle schema

You can migrate data from a MySQL database to an Oracle schema.

Before you begin

Make sure you have access to the Oracle database and have administrative privileges on the database instance. For more information, see the Oracle website.

About this task

To migrate data from MySQL to Oracle:

Procedure

  1. Create a user ID on the Oracle database that matches the schema name that will be migrated from MySQL. For example, if schema "CCDEV53" is the candidate for migration on MySQL, create a user ID named "CCDEV53" on Oracle.
  2. Install IBM® Control Center and configure it with an Oracle database. For connection parameters, provide the user ID you configured in step 1.
    Important: Do not start the engine until the migration is complete.
  3. Ensure the tables, views, and indexes relevant to IBM Control Center have been created on the Oracle database used in step 2.
  4. Download the Oracle Sql Developer version 3.1.07 or later.
  5. Launch Sql Developer.
  6. Configure the MySQL JDBC driver by clicking Tools > Preferences.
    1. Navigate to the Database section.
    2. Click Third Party JDBC Drivers.
    3. Add the MySQL JDBC driver.
  7. To establish a connection to the MySQL database, click + and select the MySQL tab.
  8. Right-click the MySQL schema and choose the option to migrate. The migration wizard opens.
  9. Follow the instructions in the migration wizard. When prompted to connect to the Oracle database, provide the user ID you configured in step 1.
  10. Validate the row counts on both the source and destination tables.
    Important: Data from the views is not migrated.
  11. Start the IBM Control Center engine.
Parent topic: Migrating data from MySQL databases