> what is tour oracle version ?
> such tool can be done easily if you put your oracle database in archivelog.
> 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
> 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
> 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).
> > 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
> > 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
> > instead of DB2 or Oracle anyways?
> > And does anybody have helpful, real, experience along these lines that
> > 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