Informix to MariaDB Migration

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

Informix to MariaDB Migration Reference

Data Types

Converting numeric data types:

Informix MariaDB
1 CHAR Fixed-length character string CHAR
2 INT, INTEGER 32-bit integer INT, INTEGER
3 SMALLINT 16-bit integer SMALLINT
4 VARCHAR Variable-length character string VARCHAR

Converting date and time data types:

Informix MariaDB
1 DATE Date - year, month and day DATE
2 DATETIME YEAR TO SECOND Date and time DATETIME
3 DATETIME YEAR TO MINUTE DATETIME Includes seconds
4 DATETIME YEAR TO FRACTION(n) Date and time with fractional seconds DATETIME(n)

SELECT Statement

Converting SQL queries:

Informix MariaDB
1 OUTER clause Outer join syntax ANSI SQL OUTER JOIN clause

ALTER TABLE Statement

Converting table statements:

Informix MariaDB
1 ALTER TABLE tab ADD
CONSTRAINT FOREIGN KEY c1
REFERENCES pk_tab
Foreign key ALTER TABLE tab ADD
FOREIGN KEY c1
REFERENCES pk_tab (pk_cols)
Primary key columns
must be specified