Oracle to MariaDB Migration

SQLines open source tools can help you transfer data, convert database schema (DDL), views, stored procedures, functions, packages, triggers, queries and SQL scripts from Oracle to MariaDB:

  • SQLines Data - Data transfer, schema migration and validation tool.
  • SQLines SQL Converter - SQL scripts conversion tool.

Databases:

  • Oracle 12c, 11g, 10g and 9i
  • MariaDB 10.x and 5.x

Migration Reference

Data Types

Date and time data types:

Oracle MariaDB
1 DATE Date and time with seconds DATETIME

Other data types:

1 XMLTYPE XML data LONGTEXT

CREATE SEQUENCE Statement

Converting CREATE SEQUENCE statement:

Oracle MariaDB
1 CREATE SEQUENCE name CREATE [OR REPLACE] [TEMPORARY]
SEQUENCE [IF NOT EXISTS] name
2 ORDER | NOORDER Guarantee sequence numbers order or not Not supported, keyword removed