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.

Regards

Josh

Josh Chamas
Director, Professional Services
MySQL Inc., www.mysql.com
Get More with MySQL! http://www.mysql.com/consulting

Options: ReplyQuote


Subject
Views
Written By
Posted
9298
gws
October 27, 2004 11:19AM
5927
November 02, 2004 06:18AM
Re: informix schema to mysql
6430
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.