-
Data types.
Defaults to NUMBER → DECIMAL
(route PKs / FKs to BIGINT per column in the
review), VARCHAR2 → VARCHAR,
CLOB → LONGTEXT,
BLOB → LONGBLOB,
RAW → VARBINARY,
DATE → DATETIME, and
TIMESTAMP → DATETIME(6).
ROWID has no MySQL equivalent — reported
in the wizard so the schema decision (drop / replace with
surrogate) is explicit.
-
Sequences and generated keys.
Collapses Oracle sequences into MySQL AUTO_INCREMENT
columns on the primary key and reseeds above the loaded
maximum key value — so application inserts do not
collide. Multi-table shared sequences need explicit
application-side emulation; MySQL has no standalone sequence
object (MariaDB does).
-
Schemas and object names.
Folds Oracle schemas into MySQL databases and normalizes
quoted mixed-case identifiers either to lowercase or
preserves backtick-quoted names — pick the policy in
the wizard so MySQL's identifier-case behavior does not
surface at application boot.
-
Application SQL portability.
Oracle-specific query syntax does not run unchanged against
MySQL: MINUS rewrites to LEFT JOIN
/ NOT EXISTS, INTERSECT to
INNER JOIN, hierarchical CONNECT BY
to WITH RECURSIVE CTEs (MySQL 8+; MySQL 5.x has
no recursive CTE), ROWNUM to LIMIT,
Oracle (+) outer joins to ANSI LEFT JOIN.
DBConvert moves the schema and data; the application SQL
layer is its own search-and-replace task.
-
Views translation — two-way.
Translates view definitions and supported queries between
Oracle and MySQL in both directions during the migration
— one of the three native two-way-translation pairs
(MySQL ↔ SQL Server, MySQL ↔ Oracle, SQL Server
↔ Oracle).
-
Stored procedures, triggers, and other procedural code — outside DBConvert's scope.
DBConvert's migration covers tables (with their fields,
types, defaults, and indexes), views, and foreign keys.
PL/SQL packages, procedures, functions, triggers, autonomous
transactions, materialized views, and DBMS_*
package calls stay in the source and are rewritten manually
in MySQL's stored-procedure dialect. Typically a small
fraction of the schema, but the one item the tool does not
handle.
