Re: AS/400 DB2 data transfer to MySQL

[Matt Laski]

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