I have a MS SQL server, there I have a DTS (data transformation services) package designed, the MS SQL connects to a DB2 Database on an IBM AS400 server, gets some data from specified tables and replicates them locally on the MS SQL Database. I need to do the same using MySQL, I'dont know if Cron will do the job or does the latest version of MySQL has this feature, and how do I use it. How do I connect to a DB2 database from MySQL to grab some data, and how do I schedule this task to run every certain time?
MySQL Migration Toolkit Googling for a solution I came across the MySQL Migration Toolkit. With this tool and JTOpen I can succesfully connect to the DB2 database on my AS400 server, grab the data I need and copy it on a MySQL table. The program can export a migration script so I guess I can use cron to run this script on a schedule. The problem is, I did all this on a Windows PC. I need to do this on my Ubuntu 6.06 Server, I have no prior experience on Linux so I don't know how to install ANYTHING, I need to install the MySQL Migration Toolkit and JTOpen. Maybe someone from this forum can offer some kind help, I am looking for information online but am having trouble finding what I need. Also I would be good to know if there is an easier solution for what I'm trying to accomplish or am I on the right track. Thanks.
I think you have to compile the MySQL migration toolkit from the sources. Download this file: http://dev.mysql.com/get/Downloads/...lkit-script-1.0.6-linux-i386.tar.gz/from/pick and unpack it. I think it contains a README or INSTALL file with further instructions. JTOpen seems to be compiled already. But again please check if it comes with a README or INSTALL file.
PHP vs. MMT (MySQL Migration Toolkit) Oops.. I didn't see a Readme file at first, but now I double checked and found the documentation, thanks. Another thing, do you think it would be a good solution to create a PHP script to get the data from de DB2 to the MySQL and schedule a cron job to run this script everyday? Do you have any ideas of Pros and Cons of doing this instead of using MMT? Thanks Falko you are of great help.
MMT on CentOS Hi jvilches, your scenario is seemingly similar to ours. This discussion is in fact an inspiration to our conceived setup and that i wanted to compile MMT on CentOS. With my readings, MMT requires Java 5.0 or 1.4.2 Runtime Environment (JRE). Is this similar to JTOpen? With yum list | grep java, the results were: db4-java.i386 gcc-java.i386 gcc4-java.i386 java-1.4.2-gcj-compat.noarch java-1.4.2-gcj-compat-devel.noarch java-1.5.0-centos.i586 java-1.5.0-centos-devel.i586 java-1.5.0-centos-jdbc.i586 java-1.5.0-centos-plugin.i586 java-1.5.0-centos-alsa.i586 java-1.5.0-centos-demo.i586 java-1.5.0-centos-fonts.i586 java-1.5.0-centos-src.i586 Do you know which of these packages corresponds to the requirement of MMT? May I also ask how successful your migration went? Your input means a lot, thanks.
Hey Nomadix23, Actually I didn't install jre nor MMT. I ended up writing a PHP script that connects to DB2 and with the help of cron I run this script every day at specified intervals... that pretty much solved my problem. I hope you can find a solution using MMT, I found the PHP script solution easier, quicker and effective for my needs.
thanks for the info, jvilches. thanks too, falko. I have actually tried installing some of the core java packages provided by CentOS but I ended up encountering multiple error messages upon executing ./run_migration. Solving one error would lead to another error until it states that it cannot find the Java Objects. Despite testimonies that installing MMT on Linux is somewhat complex, I have high hopes that we can make it run in the end. Accessing DB2 through php is also a promising alternative but will "execution timeout" be not an issue especially when data being flushed is in bulk?
