Something that I thought would be fairly easy to accomplish has taken me a week and I just keep hitting roadblocks every step of the way. I am hoping that someone has been able to achieve this and can maybe offer some tips.
The scenario is that our corporate web site (PHP using the DB2 database on our iSeries) is running really slowly, plus with recent power and internet problems, it has been decided to move it to a hosted site, which requires us to convert everything to MySQL (preferred database).
Since the data source will remain on the iSeries, so we need to be able to synchronise the DB2 content onto a MySQL database.
I looked at various solutions, which sounded easy, but proved to be far from it.
DBConvert.com has a cheap solution (with a GUI interface) that will synchronise a DB2 database with a MySQL one. I installed the software on a Windows 2008 Server, then tried to connect to the iSeries, and it requires "IBM Data Server Client" to be installed on the server. This unfortunately seems to require a paid license from IBM, and with the company paying out fee after fee for software and licenses, I am sure there must be a free way to be able to do this.
So I am stuck on the DBConvert solution, but I wondered if there was a way to synchronise DB2 with MySQL on the iSeries, and then I could synchronise that MySQL to the Windows Server, making this a 2-stage process, but at the same time giving us a backup of the MySQL database on the iSeries, which might come in handy later if we incorporate ordering facilities on the web site.
So "finally" to my question, which is: Has anyone managed to successfully synchronise DB2 on the iSeries with a MySQL database, and if so what solutions would you recommend?
I know I could write a solution in RPG, but it would be slow and tedious, and frankly why re-invent the wheel...
Thanks in advance for any help.
The scenario is that our corporate web site (PHP using the DB2 database on our iSeries) is running really slowly, plus with recent power and internet problems, it has been decided to move it to a hosted site, which requires us to convert everything to MySQL (preferred database).
Since the data source will remain on the iSeries, so we need to be able to synchronise the DB2 content onto a MySQL database.
I looked at various solutions, which sounded easy, but proved to be far from it.
DBConvert.com has a cheap solution (with a GUI interface) that will synchronise a DB2 database with a MySQL one. I installed the software on a Windows 2008 Server, then tried to connect to the iSeries, and it requires "IBM Data Server Client" to be installed on the server. This unfortunately seems to require a paid license from IBM, and with the company paying out fee after fee for software and licenses, I am sure there must be a free way to be able to do this.
So I am stuck on the DBConvert solution, but I wondered if there was a way to synchronise DB2 with MySQL on the iSeries, and then I could synchronise that MySQL to the Windows Server, making this a 2-stage process, but at the same time giving us a backup of the MySQL database on the iSeries, which might come in handy later if we incorporate ordering facilities on the web site.
So "finally" to my question, which is: Has anyone managed to successfully synchronise DB2 on the iSeries with a MySQL database, and if so what solutions would you recommend?
I know I could write a solution in RPG, but it would be slow and tedious, and frankly why re-invent the wheel...
Thanks in advance for any help.
Comment