List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:August 26 2001 2:11am
Subject:Re: MySQL Migration
View as plain text  
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,

Paul DuBois, paul@stripped
MySQL MigrationHans Zaunere25 Aug
  • RE: MySQL MigrationBernhard Preiss26 Aug
  • Re: MySQL MigrationPaul DuBois26 Aug
  • RE: MySQL MigrationBernhard Preiss26 Aug
Re: MySQL MigrationKatherine Porter26 Aug