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?
Server Fault is a question and answer site for system and network administrators. It only takes a minute to sign up.Sign up to join this community
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.
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