By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,756 Members | 1,760 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,756 IT Pros & Developers. It's quick & easy.

mysql dump into DB2 os400 database

P: 5
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.

Dec 4 '07 #1
Share this Question
Share on Google+
1 Reply

Expert 100+
P: 297

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.



P.S.: If you find a solution, please post it.
Dec 5 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.