Re: MySQL conversion
- From: Remigiusz SokoÅowski <rems@xxxxxxxx>
- To: aalurkar@xxxxxxxxxxxx
- Date: Tue, 10 Oct 2006 13:18:13 +0200
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@xxxxxxxx>
WP/PTI/DIP/ZAB (+04858) 52 15 770
MySQL v. 4.x
Oracle v. 10.x
---------------------------------------
--
//www.freelists.org/webpage/oracle-l
Other related posts:
