migration of db2 to MySQL

migration of db2 to MySQL



I am having some problem with migrating my existing db2 v5 (about 20 tables) to MySQL 3.23.

Could anyone pls tell me how to migrate them? Thanks in advance...

ningyong,

The easiest way to do this is with a client specifically written to transfer the tables. EMS MySQL Manager is capable of automatically importing tables from Excel, Access, and DBF databases, and data from CSV. This client can read the dBase file, parse it, and upload it directly into your MySQL database. EMS MySQL Manager is shareware and is available for download at the following URL:

http://ems-hitech.com/mymanager

Let me know if you have any further questions.

Dan Nichols
DGNichols@plasmified.com

-------------------------

http://www.plasmified.com
Plasmified Custom Computers

Fully Customizable PCs, Best Prices On The Market!

-------------------------

Yes, I would find some tools to do this, as you might find some datatype issues, especially with date/timestamp - type columns between DB2 and other databases. Also some numeric types perhaps. DB2 V5 is going back a ways - mainframe data?

fv

Thanks for your reply....

No, it's no mainframe data. There are total 15 tables with around 2000 records (each table).

Thanks for your useful information, I will update you once i tested.

I am having some problem with assigning a number for each displayed record.

For display 10 record and number should assigned as
1 record1
2 record2
3
.
.
.
.
10 record10

This is my code, may i know what's wrong? I have tried to count the names and assign a number (1,2...)according to the number of names displayed.

<?php
do {
$name=$row_Recordset1['SES_NAME'];
$count=count($name);
for ($i =0; $i <$count; $i++){

if($count >=0){
$j=$count + 1;}else{
$j=1;}

echo $j. $name; }

} while ($row_Recordset1 = mysql_fetch_assoc($Recordset1)); ?>

ningyong,
I took a minute to write a solution for you. This code should work if you simply replace the code you provided with it. It will automatically break each database row into an array called $myrow. This will only display the first column in the query you submitted to the database. If you would like to display the second, substitute $myrow[0] with $myrow[1].

<?php
$j = 0;
while ($line = mysql_fetch_array($Recordset1, MYSQL_ASSOC)) {
while ($myrow = mysql_fetch_row($Recordset1)) {
echo $j++ . ".) " . $myrow[0] . "<br>";
}}
?>

Thank you so much.... It works.....

[QUOTE=DGNichols]ningyong,

The easiest way to do this is with a client specifically written to transfer the tables. EMS MySQL Manager is capable of automatically importing tables from Excel, Access, and DBF databases, and data from CSV. This client can read the dBase file, parse it, and upload it directly into your MySQL database. EMS MySQL Manager is shareware and is available for download at the following URL:

URL

Let me know if you have any further questions.

Dan Nichols
URL

-------------------------

Hi Dan Nichols,

Could you please send the complete details to migrate the tables from DB2 to MySQL.

I have gone through the above answer but not succeded.

So could you please give us step by step solution for this.

Thanks and Regards
Sobhan Maddineni.