MySQL Forums
Forum List  »  IBM DB2

Re: How to get data from AS400 to MySQL
Posted by: Anders Karlsson
Date: November 04, 2004 03:25AM

I can see three basic ways of doing this:
1) Filebased. In this scenario, you export the data from DB2 in some known format, say CSV, and the schema as a plan text .sql file. Then you have to fix the schema to match what is supported by MySQL and then import the data using, say, LOAD DATA INFILE, mysqlimport. You might have to massage the data a bit before importing it. You don't say what OS you run MySQL on, so I can't tell you exactly how to go ahead and do this.

2) ODBC or JDBC based. In this scenario, you use some tool that connects to databases using ODBC or JDBC. You would then connect to both MySQL and DB2 and move the data while being connect to the two of them, or even being connected to one at the time. This will probably not aid you in migrating the schema, but the data should be OK. If you have few tables and only simple data, this could be an option, assuming of course that you have an ODBC driver for DB2. An example of a tool that I have used for this, which should only be used for small amount of data and tables, but which works for testing purposes, is Excel or some other ODBC capable spreadsheet.

3) An integrated full-blown migration tool. There are things like this around, both commercial and open-source. This page on MySQL website shows you many such tools, both commercial and open source:
http://solutions.mysql.com/software/?c=migration

/Karlsson

Options: ReplyQuote


Subject
Views
Written By
Posted
21043
November 03, 2004 05:22PM
11385
November 03, 2004 05:24PM
Re: How to get data from AS400 to MySQL
25787
November 04, 2004 03:25AM
14162
November 04, 2004 08:27AM
9783
March 15, 2005 02:17PM
11209
September 02, 2006 02:34AM


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.