Informix to MySQL 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 14.x, 12.x, 11.x, 10.x, 9.x and 7.x (Dynamic Server IDS and Extended Parallel Server XPS)
  • MySQL 8.x, 6.x, 5.x

Informix to MySQL Migration Reference

Data Types

Converting numeric data types:

Informix MySQL
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 MySQL
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 MySQL
1 OUTER clause Outer join syntax ANSI SQL OUTER JOIN clause

ALTER TABLE Statement

Converting table statements:

Informix MySQL
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