Charlie Browninge

Greenhorn
+ Follow
since Jan 17, 2005
Merit badge: grant badges
For More
Cows and Likes
Cows
Total received
0
In last 30 days
0
Total given
0
Likes
Total received
0
Received in last 30 days
0
Total given
0
Given in last 30 days
0
Forums and Threads
Scavenger Hunt
expand Ranch Hand Scavenger Hunt
expand Greenhorn Scavenger Hunt

Recent posts by Charlie Browninge

Originally posted by Ritchie Warsi:

Other advice is always still welcome.

edit: Oracle exp makes a dump right? As far as I know MySQL can't read/import Oracle dumps...or has this changed recently?

edit2: Nevermind, Oracle's CSV export can be read by MySQL it seems.

[ January 06, 2005: Message edited by: Ritchie Warsi ]




Hi Ritchie,

I don't know how tight is your budget for this project.
You may want to look FastReader www.wisdomforce.com

FastReader extracts large Oracle tables into flat file with any delimiter (csv type)or xml. At same time FastReader generates loaders for major databases, including MySQL. You can easily set up some automatic scripts with that. I am using FastReader to unload very large Oracle tables (tens millions of rows) into MS SQL Server. Works very well for me, fast and effective, supports most Oracle data types, including binary, blobs, cblobs, etc.