Re: Transfer data from MySQL to Oracle

Bing Du Test wrote:
> What do people usually use to transfer a large number (e.g. 150,000)
> from one kind of database (e.g. MySQL) to another (e.g. Oracle)? Thanks
> in advance for any ideas and pointers.
>
> Bing
>

depends. 8^)

How big is the source DB? Is that "large number" refering to the number of records? (in which case 150,000 is small) or the number of tables? (man that's BIG) how complex is the source data model? (many tables realtions?? will the model remain the same in Oracle??)

Some suggestions include

brute force method: Dump the source DB to text files and load the Oracle DB with a combination of SQL*Loader, SQL and PL/SQL, remapping the data to tables as needed.

Program method: use PERL and DBI to connect to both databases and move the data, performing any transformations needed along the way.

Oracle method: use the Heterogenous services to connect from Oracle to the MySQl DB and move the data, performing any transformations using SQL, PL/SQL.

-- 
Ed Prochak
running    http://www.faqs.org/faqs/running-faq/
netiquette http://www.psg.com/emily.html
--
"Two roads diverged in a wood and I
I took the one less travelled by
and that has made all the difference."
robert frost