MySQL Forums
Forum List  »  IBM DB2

Re: AS/400 DB2 data transfer to MySQL
Posted by: Matt Laski
Date: September 07, 2007 11:35AM

I replicate a large portion of the files of our AS400 to a mySQL database on a regular basis (some tables are hourly, others daily). I did this using a homemade vbScript that I wrote. My script is way more complicated than you would need, but for you it would be a relatively easy script to put together.

My script downloads data from the AS400 into a CSV. That CSV is then imported into the mySQL Master server (which has two slaves in branch offices) and then FTP'ed up to a public website (which ... for reasons I wont get into ... can't communicate directly with our as400 for data ... hence the need to FTP a CSV).

The script uses ODBC to communicate with the 400 and with the mySQL server.

Its definately not the most elegant solution, but it works pretty well considering our needs for the data.

Hope this helps,

~Matt

Options: ReplyQuote


Subject
Views
Written By
Posted
12517
June 19, 2007 09:22AM
Re: AS/400 DB2 data transfer to MySQL
7422
September 07, 2007 11:35AM


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.