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

• Data Types
• SELECT
• ALTER TABLE

Converting numeric data types:

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)

Converting SQL queries:

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