Step-by-Step MySQL to Oracle Conversion Using DRPU Database Converter

How to Convert MySQL to Oracle with DRPU Database Converter

Overview

DRPU Database Converter automates migrating schema and data from MySQL to Oracle, reducing manual SQL translation and preserving data types, keys, and indexes where possible.

Prerequisites

• Install DRPU Database Converter on the machine with network access to both databases.
• MySQL server credentials (host, port, database, user, password).
• Oracle server credentials (host, port, service/SID, user, password).
• Appropriate client drivers/ODBC/JDBC if required by the converter.
• Backup of both databases before starting.

Step-by-step migration

1. Launch the converter

   • Open DRPU Database Converter and choose the source database type as MySQL and target as Oracle.

2. Connect to MySQL

   • Enter MySQL connection details and test the connection.
   • Select the specific database and the objects (tables, views, procedures) to migrate.

3. Configure Oracle connection

   • Enter Oracle connection details (TNS/service name or SID, port, username, password).
   • Test the Oracle connection and ensure the target schema/user has necessary privileges (CREATE, INSERT, ALTER).

4. Map data types and settings

   • Review automatic data type mappings (e.g., MySQL VARCHAR -> Oracle VARCHAR2).
   • Adjust mappings for types with no direct equivalent (e.g., MySQL TINYINT -> Oracle NUMBER(3) or CHAR).
   • Set options for handling auto-increment fields, primary keys, foreign keys, and indexes.

5. Select conversion options

   • Choose whether to generate DDL only, migrate data only, or perform full migration.
   • Configure batch size, commit frequency, and error handling (skip on error, stop on error, log errors).
   • Optionally enable transformations (column renames, data filtering).

6. Preview and generate scripts

   • Use the preview to inspect generated Oracle DDL and data load scripts.
   • Save or edit scripts if you prefer manual execution.

7. Execute migration

   • Run the conversion within the tool or execute exported scripts on the Oracle server.
   • Monitor progress logs and resolve any reported issues (type conflicts, constraint violations).

8. Validate migrated data

   • Compare row counts for each table between MySQL and Oracle.
   • Spot-check data correctness for key tables and fields.
   • Verify indexes, primary/foreign keys, constraints, and stored procedures where applicable.

9. Post-migration tasks

   • Rebuild or optimize indexes on Oracle.
   • Update application connection strings and test application functionality.
   • Remove or disable triggers