This week's book giveaway is in the Mac OS forum. We're giving away four copies of a choice of "Take Control of Upgrading to Yosemite" or "Take Control of Automating Your Mac" and have Joe Kissell on-line! See this thread for details.
Not really. You may have some luck with export/import tools but depending on the data types used it may still require some conversions. I find the best way to do something like this is write a JDBC tool that reads a record from one database and inserts it into another after performing some conversions. The non-conversion JDBC code should be about a page long.
Yes data conversion is another area which need to be addressed, In SQL loader we can also convert the Data in desired format before inserting into table, also in term of performance I have very good experience with SQL loaders.
I used to insert approx 2 million records in oracle within 5 minutes.