Re: MySQL conversion

Aditya Alurkar wrote:

>Since MySQL allows you to "dump" data directly to CSV files you can always
>dump the data and use something like SQLoader to import it into oracle, if
>you want to get all fancy perl would be good choice to move the data/maybe
>even create the tables.
>
>A quick google search resulted in http://iheavy.com/node/51 which seems like
>a good starting point as well
>
>
>
>

I would also recommend that way (CSV files) - I think it is possible to attach CSV files as external tables
directly to Oracle (and doing the rest with Oracle SQL by simple CREATE AS SELECT)
for example http://www.adp-gmbh.ch/ora/misc/ext_table.html or http://www.oracle.com/technology/pub/articles/10gdba/week16_10gdba.html

regards
Remigiusz

-- 
---------------------------------------
Remigiusz Sokolowski <rems_at_wp-sa.pl>
WP/PTI/DIP/ZAB (+04858) 52 15 770
MySQL  v.  4.x
Oracle v. 10.x
---------------------------------------

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