gws wrote:
> I have an active informix db that I would like to
> move to mysql. I am having a hard time finding a
> simple converter to convert a text dump of the
> schema and data to mysql syntax.
>
> Does anyone have any suggestions.
>
Usually, I can pop schema DDL into a text editor and tweak column types pretty easily for a database migration. What kind of table definitions are you having a problem with?
For a data transfer, this can be pretty trivially scripted via DBI, JDBC or ODBC. If you need a sample that would move data from one database to another, I can drop in a bit here.
Regards
Josh
Josh Chamas
Director, Professional Services
MySQL Inc., www.mysql.com
Get More with MySQL!
http://www.mysql.com/consulting