getting data from MySQL to IBM DB2
| From: | Andreas Korthaus | Date: | Wed, 20 Aug 2003 14:44:29 +0000 |
| Subject: | getting data from MySQL to IBM DB2 | ||
| References: | 1 2 3 | Groups: | php.pear.general |
| Request: | Send a blank email to pear-general+get-7307@lists.php.net to get a copy of this message | ||
Hi!
I'm using MySQL with PEAR::DB. Now I want to migrate to DB2, how should I do
this? The first problem is that the SQL-Commands are not 100% comatible, so
I cannot use a dump, right? So I have to export the data in CVS format and
create the tables in DB2 myself. But what about "nextID()" tables? I cannot
copy theses tables to DB2, but if PEAR generates new tables, it will start
counting with ID=1.., but I have a lot of data and therefore higher IDs. How
could I handle this?
Thank You!
Kind regards,
Andreas Korthaus