MariaDB to Oracle Migration

SQLines tools can help you transfer data, convert database schema (DDL), views, stored procedures and functions, triggers, queries, embedded SQL statements and SQL scripts from MariaDB to Oracle.

Databases:

  • MariaDB 11.x and 10.x
  • Oracle 21c, 19c, 18c, 12c and 11g R2

Migration Reference

Built-in SQL Functions

Converting datetime functions:

MariaDB Oracle
1 CURRENT_TIMESTAMP Get the current date and time CURRENT_TIMESTAMP
CURRENT_TIMESTAMP() CURRENT_TIMESTAMP
CURRENT_TIMESTAMP(n) CURRENT_TIMESTAMP(n)