At 10:39 AM -0700 8/25/01, Hans Zaunere wrote:
>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.
Oracle has some kind of MySQL-to-Oracle tool. Check their
Web site. I've never used it, so I can't comment on how
well it works.
>
>Thank you,
>
>Hans
>[EMAIL PROTECTED]
--
Paul DuBois, [EMAIL PROTECTED]
---------------------------------------------------------------------
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
