[rt-users] Re: database migration
David Cecchino
cecchind at qwestip.net
Wed Apr 21 07:44:09 EDT 2004
Rick Does that also work for mysql version 4 , or are you running 3x
version?
-dave
On Wed, 21 Apr 2004, Rick Ellis wrote:
> 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>
>
> _______________________________________________
> http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
>
> RT Developer and Administrator training is coming to LA, DC and Frankfurt this spring and summer.
> http://bestpractical.com/services/training.html
>
> Sign up early, as class space is limited.
>
More information about the rt-users
mailing list