Hi There,

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.

Many Thanks In Advance