Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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
add comment

2 Answers 2

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
add comment

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: www.ibm.com/informix

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

Your Answer

 
discard

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