Re: Migrate/Export data from Oracle to MySQL

From: Steve Howard <stevedhoward_at_gmail.com>
Date: Tue, 22 Feb 2011 16:46:14 -0800 (PST)
Message-ID: <00e417be-645c-42a6-b1b8-292a5167c5e1_at_w36g2000vbi.googlegroups.com>

On Feb 10, 8:54 am, trub3101 <trub3..._at_sky.com> wrote:
> On Feb 10, 12:59 pm, John Hurley <hurleyjo..._at_yahoo.com> wrote:
>
> > On Feb 10, 7:16 am, trub3101 <trub3..._at_sky.com> wrote:
>
> > > Hi,
>
> > > Oracle 9.2.0.8 Enterprise (Linux)
> > > MySQL (Windows)
>
> > > Could anyone provide me with a solution(s) to export/migrate schemas
> > > from Oracle to MySql?
>
> > > Thanks in advance,
>
> > > tb3101
>
> > What have you tried so far?
>
> I have converted a table to tab delimited files and used the MySql
> LOAD DATA INFILE command.

We actually just did this, and migrated about 1TB single table to a reporting database. It took three days, but we hand coded the migration. We pulled it from Oracle into java, and from there pushed it into MySQL. We chose this because we had unicode data, and we knew java would handle it without losing any bits. Received on Tue Feb 22 2011 - 18:46:14 CST