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