Re: Oracle to MySQL integration

From: Heikki Tuuri <Heikki.Tuuri_at_innodb.com>
Date: Wed, 10 Mar 2004 08:29:56 GMT
Message-ID: <8mA3c.40$RR5.2@read3.inet.fi>

Mark,

"Mark" <simmons_mark_at_yahoo.com> kirjoitti viestissä news:5366fb41.0403051525.6f234a9b_at_posting.google.com...
> Our company is contemplating using MySQL for denormalized R/O WEB
> transactions that don't require read consistency.

note that InnoDB tables in MySQL have a similar consistent, non-locking read capability as Oracle.

> 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

Best regards,

Heikki Tuuri
Innobase Oy
Foreign keys, transactions, and row level locking for MySQL InnoDB Hot Backup - a hot backup tool for InnoDB which also backs up MyISAM tables
http://www.innodb.com/order.php Received on Wed Mar 10 2004 - 02:29:56 CST