Re: Export DDL and data to MYSQL

From: Guillermo Alan Bort <cicciuxdba_at_gmail.com>
Date: Wed, 11 Nov 2009 10:27:41 -0300
Message-ID: <172762180911110527j5c7bb7cbl223774ae4b678ce8_at_mail.gmail.com>

I've only done this using highly customized scripts knowing the data model very well. I reckon it should be possible to an extent. There are some things you simply can't reproduce in MySQL.

As for data, a simple CSV should suffice. Alternativeley you can generate a sql dump of the db with sql generators running a query that generates a file with the insert statements. For instance:

select 'insert into table1 values ('''||col1||''','''||'''col2''',''col3)' from table1); or something like that... though it's not the easyest way and you'd have to account for referential integrity manually.

Also, you should know that DDL changes from Oracle to MySQL in several simple things (like varhcar2 is varchar, and there is no number type, you have to use either integer or float or double).

hth
Alan Bort
Oracle Certified Professional

On Wed, Nov 11, 2009 at 7:37 AM, John Dunn <JDunn_at_sefas.com> wrote:

> Does anyone have experience of exporting DDL and data from Oracle to
> MYSQL?
>
> If so, what tools would you recommend?
>
>
> John
>
>
>
> **
>
>
>
>

--
http://www.freelists.org/webpage/oracle-l

Received on Wed Nov 11 2009 - 07:27:41 CST