Migrate the whole database
Schema, data and indexes in one run.
- Every MySQL table is created in Oracle with mapped types
- Start here when the target schema does not exist yet
Withdata DBCopier - Secure, Fast, and Cross-Platform Tool for MySQL to Oracle Data Transfer

Eight operations, one dialog. The first three move a whole database or one table, the next two take many tables, the last three keep the two sides in step or run the job for you.
Schema, data and indexes in one run.
The table is created in the Oracle schema of the connecting user.
The MySQL SELECT runs on MySQL; Oracle receives rows.
LIMIT has no Oracle equivalent inside a copied queryMany tables, one pass.
Similar means the same mapped column list.
MySQL types map to Oracle types with explicit sizes.
LONGTEXT → CLOB, LONGBLOB → BLOBDATETIME → TIMESTAMP; TINYINT(1) → NUMBER(1)Incremental sync matches on a unique key.
AUTO_INCREMENT values are copied as-isRun it on a timer.
.bat or .sh| MySQL | Oracle |
|---|---|
INT | NUMBER(10) |
BIGINT | NUMBER(19) |
DECIMAL(p,s) | NUMBER(p,s) |
DOUBLE | BINARY_DOUBLE |
VARCHAR(n) | VARCHAR2(n) |
LONGTEXT | CLOB |
DATE | DATE |
DATETIME | TIMESTAMP |
LONGBLOB | BLOB |
TINYINT(1) | NUMBER(1) |
JSON | CLOB |
.sql dump is not parsed — if a dump is all you have, restore it into a MySQL instance first. It is also not an online service: nothing is uploaded, the copy runs on your own machine.
Get the full version Withdata DBCopier for your operating system and start seamless MySQL to Oracle data transfer
$129 one-time · volume discounts to $99 · 30-day money-back · pricing & licence terms · Oracle to MySQL →