Bulk SQL Server to Oracle Copy

oracle sqlbulkcopy sql-server

Question

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.

1
0
10/21/2009 2:02:13 AM

Popular Answer

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.

1
11/16/2009 9:46:56 PM


Related Questions





Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow
Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow