Hello Hans,
a few weeks ago i had a similar task to accomplish, porting a mySQL
DB over to IBM's DB2 for S/390, so i can relate to this kind of
*most exciting* job.
Anyway, from my experience I wouldn't recommend anything like a bulk
copy or mass import/export. Because when you are switching to a
different DB vendor you will always have difference in field length,
types etc. So the best would be to pick some records from the mySQL
database that contains all information you will have to bring into
the oracle system.
An oracle script should do the data validation, mapping to the new
fields and inserting into the new db. After all the new rows will be
transferred you can walk through those records and check if all trans-
actions went well. If all information arrived in the right format and
length than you can import the bulk.
Regards,
Bernhard
-----Original Message-----
From: Hans Zaunere [mailto:[EMAIL PROTECTED]]
Sent: Saturday, August 25, 2001 7:40 PM
To: [EMAIL PROTECTED]
Subject: MySQL Migration
We have about 300,000 records currently in a MySQL
database. A new system has been built on Oracle, and
now we must migrate the data from MySQL to Oracle (I
know, it's not something I wanted to do.) What is the
best way to do this? Import into another database
(something like Access) then export to Oracle?
Scripting on the Oracle side that would do this? Mind
you there is about 300,000 records, so this isn't a
menial task, neseccarily. Also, although the two
databases are of similar structure, they aren't
identical, so some translation would be needed.
Thank you,
Hans
[EMAIL PROTECTED]
__________________________________________________
Do You Yahoo!?
Make international calls for as low as $.04/minute with Yahoo! Messenger
http://phonecard.yahoo.com/
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail
<[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
