List:General Discussion« Previous MessageNext Message »
From:Martijn Tonies Date:June 6 2005 9:19am
Subject:Re: mirroring oracle database
View as plain text  
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

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