Re: Migration of DB2/AS400 to mysql fails
Posted by: Rainer Rohmfeld
Date: December 30, 2005 02:38AM

Hallo again!!

Some advices on working with MySQL Migration Toolkit for migrating IBM DB2 on AS400/iSeries to MySQL:

1. Download JTOpen, the open Source version of the IBM Toolbox for Java from
http://jt400.sourceforge.net/. At time of writing this is jtopen_4_9.zip

2. Unzip the toolkit and copy the *.jar files to Your Java class path for the Migration Toolkit, i.e. C:\Programme\MySQL\MySQL Migration Toolkit 1.0\java\lib on Windows, if You have choosen standard installation options

3. Start the Migration toolkit and configure source database:
Database System: Generic Jdbc
Class name: com.ibm.as400.access.AS400JDBCDriver
Connection String: jdbc:as400://iSeries_hostname/;

4. Configure target database

5. Connection progress; You will be prompted for the user/password to connect to the iSeries/AS400.

6. Choose the database You want to migrate

7. etc.


That's all!!!

Options: ReplyQuote


Subject
Written By
Posted
Re: Migration of DB2/AS400 to mysql fails
December 30, 2005 02:38AM


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.