The mass transfer of data from SQL Server to Oracle is a need I have for a project. The data reader from SQL Server must first be converted into a CSV file before I can export it using OracleBulkCopy from DataDirect and ODP.net. This procedure is quite ineffective, therefore I was wondering if there was an other approach. A linked server cannot be used.
If you utilize SSIS, you shouldn't need to create a text file first in order to import data straight into an Oracle database. This requires that your network has access to the Oracle database.