List:General Discussion« Previous MessageNext Message »
From:mfatene Date:June 6 2005 6:11am
Subject:Re: mirroring oracle database
View as plain text  
Hi,
what is tour oracle version ?

such tool can be done easily if you put your oracle database in archivelog. Be
carrefull to datatypes and create your mysql database with innodb storage.

Beginning the game, you can use LogMiner. A simple batch can extract the redo
SQL statements and apply them to your mysql database.

This will be another Heterogeneous DataGuard architecture. Why not if you have
not stored procedures, triggers, views ... in your oracle database. This will
surprise me if you answer me "i haven't".

Since it's a "test like", you can install mysql v5 which supports those
concepts.

A+

Mathias

Selon Edward Peschko <esp5@stripped>:

> On Sun, Jun 05, 2005 at 04:41:16PM -0700, sol beach wrote:
> > IMO, you have much more a lively imagination than realistic, in depth
> > & technical knowlege in either MYSQL or Oracle.
> > Current production MYSQL does NOT have stored procedures.
>
> Current production mysql doesn't, but current development does (5.02).
>
> Given that this is something that is coming online about 6 months down the
> fly,
> and is a direction that we are thinking about moving, and given how much
> that such an effort would save you - and given the fact that all the data
> in question is being backed up in an oracle database, as far as I can see,
> the risk is minor and the rewards major.
>
> All it really has to do is keep data for a minor interval (say, a day). Then
> it can be synced with the oracle database in a batch job.
>
> I say its worth a shot. If its not doable now, its perhaps doable in 6
> months.
> And some people agree with me apparently:
>
>     http://www.convert-in.com/ora2sql.htm
>
> which I was thinking about reverse engineering to an extent as a starting
> point.
>
> Thanks for the vote of confidence btw, and the elegent, almost statesman-way
> that you expressed it..
>
> But seriously, why the testy response? Are you affiliated in any way with
> oracle?
> Isn't the whole point of mysql to ultimately provide a RDBMS that can be used
> instead of DB2 or Oracle anyways?
>
> And does anybody have helpful, real, experience along these lines that they'd
> like to share rather than just opinions?
>
> Ed
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:    http://lists.mysql.com/mysql?unsub=1
>
>


Thread
mirroring oracle databaseEdward Peschko6 Jun
  • Re: mirroring oracle databaseMartijn Tonies6 Jun
Re: mirroring oracle databaseEdward Peschko6 Jun
  • Re: mirroring oracle databasemfatene6 Jun
Re: mirroring oracle databasemfatene6 Jun