Re: Oracle to MySQL integration

I was thinking along the lines of a product like Golden Gate that reads the Oracle logs and applies them to MySQL.

We have a requirement to support about 200 transactions/second into the denormalized model. We can easily do this with a pure Oracle model, but the hardware/software licensing is very expensive.

Any other input would appreciated.

Mark Simmons
Sr. Oracle DBA
Sabre-Holdings, Southlake, TX

Mark Bole <makbo_at_pacbell.net> wrote in message news:<AZ92c.20481$g45.1013_at_newssvr29.news.prodigy.com>...
> Mark wrote:
>
> > Our company is contemplating using MySQL for denormalized R/O WEB
> > transactions that don't require read consistency.
> >
> > Does anyone have any recommendations on the best method to move data
> > from a normalized Oracle database into a de-normalized MySQL database?
> >
> > Thanks.
> >
> > Mark
>
> Use a tool such as JDBC, Perl DBI, or ODBC. Make one connection to your
> Oracle source database and another to your MySQL target database.
>
> For each de-normalized relation, "insert into target select [using
> de-normalized relation] from source".
>
> --Mark Bole
Received on Wed Mar 10 2004 - 14:09:54 CST