MySQL Forums
Forum List  »  Informix

Re: Informix blob data migration
Posted by: Partha Dutta
Date: June 30, 2005 09:56AM

I personally have not done this before. You can't use the "UNLOAD" statement because the blob would not be written out correctly. One possibility is to start writing some small custom programs. If you have ever used the High Performance Loader (HPL) utility, it can write out the raw data for the table quite rapidly in parallel. The data for the table is literally written out byte for byte, and it is possible to read it in with a C, C++ or Java application, and then load that data into MySQL.

If you use a lot of Java, then there might be one other solution called C-JDBC. You might be able to use this product to replicate between Informix and MySQL, and then break off the replication, thus creating a migration from Informix to MySQL.

Partha Dutta
Senior Consultant, MySQL Inc.

Options: ReplyQuote

Written By
June 30, 2005 03:35AM
Re: Informix blob data migration
June 30, 2005 09:56AM

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.