MySQL Forums
Forum List  »  Informix

Extracting Informix data
Posted by: Alex Rebrik
Date: May 06, 2005 12:28PM

Greetings everyone!

I'm in a process of trying to convert an Informix DB to MySQL, at first it seemed like a straight forward though somewhat tedious process:

- extract schema with "dbschema"
- extract data in form of SQL statements with "dbexport"
- hack a quick script(s) to convert DDL schema to CREATE / GRANT statements (
- import into MySQL

the problem I'm having is that I can not afford to take the Informix DB off-line so that "dbexport" can do its job which requires an exclusive lock on all tables (records?).

QUESTION: Is there any other way to export data to a text file in form of INSERT statements from a live DB?

Pardon me if I'm missing the obvious - I've never worked with Informix before and all I know of it is what I was able to piece together from FAQs / forums out there.

Alex Rebrik

Options: ReplyQuote

Written By
Extracting Informix data
May 06, 2005 12:28PM
June 08, 2005 10:04AM
September 14, 2005 06:59AM

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.