Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

We have a old Informix Database at my place of employment and are looking for a solid solution for migrating all of the data from Informix to MySQL.

Does anyone have knowledge of a proven solution for this migration?

share|improve this question

Is the schema too large or too complex to edit manually? Informix and MySQL syntax is very similar and you should be able to clean the sql statements just using some sed scripts.

There are many tools available and a MySQL resource discussing various options can be found here, but I would be inclined to just dump the dbschema, try and load it into MySQL and fix the bits that break.

share|improve this answer

Just for Information, if the problem is the cost with Informix license upgrade, you can use the new Informix Innovator-C v11.50 , what is Free for production.

Supports 1 socket CPU (or 4 cores), No sessions/user limits, 2 GB memory, no database size limit, support 2 nodes in High Availability for free, support 2 nodes in Enterprise Replication for free, Optional official IBM support contract... if need...

Check the IBM site for more information:

share|improve this answer
Also: (which redirects to the IBM site). The URL editor removed the www. when that was prefixed with 'http://'; that is frustrating because does not work the same as does. – Jonathan Leffler Sep 30 '10 at 5:49

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.