Re: mirroring oracle database
Hello Edward, I'm trying to convince some people here to adopt MySql as a relational database here. However, we can't start from a clean slate; we have a very mature oracle database that applications point to right now, and so we need a migration path. I was thinking of taking the following steps: a) finding a Java API that transparently supports both MySQL and Oracle data access and stored procedure calls. b) instrumenting the Oracle database so that all tables support timestamps on data rows. c) mirroring the Oracle database in MySQL. d) making interface code connecting the MySQL database to the Oracle database (and both applying updates to the database as well as data. In other words, I'm looking to make a MySQL - Oracle mirroring tool, and was wondering if anybody had experience with this sort of thing. As I see it, if we pull this off we could save quite a bit in licensing costs - we'd still have oracle around, but it would only be a datastore for talking to other oracle databases, and run by batch, not accessed by end users. Ed ( ps - here are the concerns I have right now about doing this... How well can stored procs be translated over? how about views, triggers and indexes? ) MySQL doesn't have CHECK constraints. Only version 5 (which is in early beta) has Views, Triggers and Stored Procedures. IF you can convert your existing application to MySQL is heavily depending on what you're using with Oracle... As a personal note: if you want to save license costs, did you ever take a look at Fyracle? http://www.janus-software.com/fb_fyracle.html With regards, Martijn Tonies Database Workbench - tool for InterBase, Firebird, MySQL, Oracle MS SQL Server Upscene Productions http://www.upscene.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: mirroring oracle database
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]
Re: mirroring oracle database
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]
mirroring oracle database
hey all, I'm trying to convince some people here to adopt MySql as a relational database here. However, we can't start from a clean slate; we have a very mature oracle database that applications point to right now, and so we need a migration path. I was thinking of taking the following steps: a) finding a Java API that transparently supports both MySQL and Oracle data access and stored procedure calls. b) instrumenting the Oracle database so that all tables support timestamps on data rows. c) mirroring the Oracle database in MySQL. d) making interface code connecting the MySQL database to the Oracle database (and both applying updates to the database as well as data. In other words, I'm looking to make a MySQL - Oracle mirroring tool, and was wondering if anybody had experience with this sort of thing. As I see it, if we pull this off we could save quite a bit in licensing costs - we'd still have oracle around, but it would only be a datastore for talking to other oracle databases, and run by batch, not accessed by end users. Ed ( ps - here are the concerns I have right now about doing this... How well can stored procs be translated over? how about views, triggers and indexes? ) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: mirroring oracle database
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]