[rt-users] Re: database migration

[Rick Ellis]

Hi David,

I have spoken to two of our Oracle DBA's this morning and they tell me
that Oracle can handle Mysqldump files perfectly well.

To prove a point, they used my backup dump files to create an Oracle
instance on our dev server.

So long as the sql you output is valid, "Oracle doesn't care". They said
try sql plus or sequencer.

Rik


> Message: 2
> Date: Tue, 20 Apr 2004 16:27:07 -0400 (EDT)
> From: David Cecchino <cecchind at qwestip.net>
> Subject: Re: [rt-users] database migration
> To: Les Mikesell <les at futuresource.com>
> Cc: rt-users at lists.bestpractical.com
> Message-ID: <Pine.GSO.4.58L0.0404201626500.7620 at qmail>
> Content-Type: TEXT/PLAIN; charset=US-ASCII
> 
> thats just for mysql to mysql, i need mysql -> oracle , thanks for the
> reply.
> 
> dave
> 
> 
> 
> On Tue, 20 Apr 2004, Les Mikesell wrote:
> 
> > On Tue, 2004-04-20 at 09:08, David Cecchino wrote:
> >
> > > Had a quick question I have a webrt system running 3.0.9 with mysql, I
> > > have a dev box running webrt 3.0.10 with oracle 9i. I have the mysql
> > > dumped , just need a nice way of importing the data, I was wondering if
> > > anyone out there has a way or maybe can share some information.
> >
> > "man mysqldump" for details.  It suggests:
> >
> > mysqldump --opt database | mysql --host=remote-host -C database
> > as one way to move a database - or redirect to a file on the
> > dump and from the file on the restore.
> >
> > ---
> >   Les Mikesell
> >     les at futuresource.com
> >
> >
> >
> >
> 

-- 
Rick Ellis <Richard.Ellis at Sun.COM>