dbschema -d dbname dbname.sql
That will put a complete schema in the file dbname.sql -- you will have
to edit it for use with MySQL, particularly if you have views, stored
procedures and triggers, but also some basic syntax (MySQL will let you
know what you need to change).
Konrad Mathieu wrote:
>I am a newbee to Informix, how would I dump a complete database with all
>tables, column names etc to something sql which can be ported to e.g. MySQL?
>
>Thanks and cheers,
>Konrad
>
>
>
>