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.
Paul DuBois, paul@stripped