MySQL Forums
Forum List  »  Informix

Re: informix schema to mysql
Posted by: Josh Chamas
Date: November 17, 2004 11:24AM

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.



Josh Chamas
Director, Professional Services
MySQL Inc.,
Get More with MySQL!

Options: ReplyQuote

Written By
October 27, 2004 11:19AM
November 02, 2004 06:18AM
Re: informix schema to mysql
November 17, 2004 11:24AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.