mysql dump into DB2 os400 database

[renestigter]

hi all,

I am not an SQL expert but have experience with DB2 on the Iseries/AS400.
I simply want to generate an SQL database in OS400 DB2.
My idea was to create a dump of the MySQL database so I have a script with the create table statements etc.
If I execute this script in OS400 I get all kind of errors refering to incorrect field types, incorrect intial values etc.
Anyone has an idea of conversion programs, or something which can help me to quickly generate this database?
The goal is to run my java applications on DB2 OS400 without changing the code.

thanks.

[docdiesel]

Hi,

I believe there's no easy way to migrate data from MySQL to DB2, and you may even have to change some code in your java applications. As DB2 told you, there're differences in field definitions, e.g. there's no TEXT type like in MySQL. Instead you'll have to use someting like Varchar(). So you'll have to check and probably adapt the table definitions before setting them up in DB2.

After that, things could be easy. Afaik MySQL is writing backups in form of INSERT statements. With a little luck, you may run them as sql scripts against DB2 without changes.

Regards,

Bernd

P.S.: If you find a solution, please post it.