Differences

This shows you the differences between two versions of the page.

oracle-to-mariadb [May 29, 2019 11:34 pm]
sqlines
oracle-to-mariadb [July 04, 2020 1:14 pm] (current)
sqlines
Line 1: Line 1:
====== Oracle to MariaDB Migration ====== ====== 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 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
 + 
 +We also help convert embedded SQL statements in C/C++ (ODBC, Pro*C, OCI, OCCI), C#, Java, PowerBuilder, VB/VB.NET, ASP/ASP.NET, Perl, PHP, Python, Linux shell and other applications.
  * [[/sqldata/oracle-to-mariadb|SQLines Data]] - Data transfer, schema migration and validation tool   * [[/sqldata/oracle-to-mariadb|SQLines Data]] - Data transfer, schema migration and validation tool
-  * SQLines SQL Converter - SQL scripts conversion tool+  * SQLines SQL Converter - SQL scripts assessment and conversion tool
**Databases:** **Databases:**
-  * Oracle 12c, 11g, 10g and 9i+  * Oracle 19c, 18c, 12c, 11g, 10g and 9i
  * MariaDB 10.x and 5.x     * MariaDB 10.x and 5.x  
Line 21: Line 23:
===== Data Types ===== ===== Data Types =====
 +
 +Character data types:
 +
 +| 1 | CLOB | Character large object, <= 4G | LONGTEXT |
 +
 +Numeric data types:
 +
 +| 1 | DECIMAL(//p,s//), DEC(//p,s//) | Fixed-point number | DECIMAL(//p,s//), DEC(//p,s//) |
Date and time data types: Date and time data types:
Line 26: Line 36:
|  | **Oracle** || **MariaDB** || |  | **Oracle** || **MariaDB** ||
| 1 | DATE | Date and time with seconds {{:exclamation.png|}} | DATETIME || | 1 | DATE | Date and time with seconds {{:exclamation.png|}} | DATETIME ||
 +
 +Binary data types:
 +
 +| 1 | BLOB | Binary large object, <= 4G | LONGBLOB |
Other data types: Other data types: