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 data types:

Informix MySQL
CHAR Fixed-length character string CHAR
INT, INTEGER 32-bit integer INT, INTEGER
SMALLINT 16-bit integer SMALLINT
VARCHAR Variable-length character string VARCHAR

SELECT Statement

Converting SQL queries:

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