resubmitted Selon [EMAIL PROTECTED]:
> 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 <[EMAIL PROTECTED]>: > > > 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/[EMAIL PROTECTED] > > > > > > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
