tags:

views:

16

answers:

0
Q: 

what is the fastest way to load data from sql DB to Oracle DB

Other than DTS packages..what is a best/fastest way to transfer considerably heavy amount of data from SQL Server DB to Oracle DB (~million rows).

I cant pay for the tool so something opensource or free will suit my needs.

related questions

Change datatype when importing Excel file into Access
What powers Google Charts?
Storing SAS data (including table structure) in a single flat file
How would you go about reverse engineering a set of binary data pulled from a device?
How to get scientific results from non-experimental data (datamining?)
Looking for tool to generate random CSV data
Suggestions for human editable data file format/parsing library
Advice on handling large data volumes.
What's a good way to store raster data?
How do I protect my file data from disk corruption?
Sql Server compatibility mode
Infopath 2007 - How do I perform data validation on the current view ONLY?
Mending bad BAD database design once data is in the system.
Embed data in a C++ program
Astoria vs. SQL Server Data Services
What is the best way to implement soft deletion?
C# NetCDF Library
Program for working with large CSV Files
What is the best strategy for retainment of large data sets?
Data Auditing in NHibernate and SqlServer
Large Data Sets
Configurable Table Prefixes with a .Net OR/M?
Are there any decent free JAVA data plotting libraries out there?
Peak detection of measured signal
Data verifications in Getter/Setter or elsewhere ?