Unanswered: Exporting Tables + content from IDS 9.4 to MySQL 4
We have Informix IDS 9.4 as our DB backend, but I would like to copy the tables and the content from my informix database to MySQL v4.0.
How would I go about doing this I have tried doing dbschema -d [Database Name] -t [table Name] -p all > table_file.sql and then using MySQL control Center to then open and execute the sql file but it keeps coming up with syntax errors. I think I am going about this the wrong way.
Has anyone done this or knows how to do this, if you could let me know that would be gratefully received.