Re: Oracle to MySQL integration

From: Mark Bole <makbo_at_pacbell.net>
Date: Sat, 06 Mar 2004 01:39:44 GMT
Message-ID: <AZ92c.20481$g45.1013@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 Fri Mar 05 2004 - 19:39:44 CST