MySQL does have a program mysqlimport. I, myself, being a scripting gal would most
probably dump my Oracle DB into a comma delimited file or straight out raw SQL and
make the text substitions to match the INSERT and CREATE TABLE syntax. Post a sample
of your dump file and I can help you forge an import script.
[.kate]
-----Original Message-----
From: Hans Zaunere [EMAIL PROTECTED]
Sent: Sat, 25 Aug 2001 10:39:52 -0700 (PDT)
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
___________________________________________________________________________
Visit http://www.visto.com.
Find out how companies are linking mobile users to the
enterprise with Visto.
---------------------------------------------------------------------
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
