Bulk SQL Server to Oracle Copy

oracle sqlbulkcopy sql-server

Question

I have a requirement for a project to move data from SQL Server to Oracle in bulk mode. There is OracleBulkCopy from DataDirect and ODP .net but to use that I have to first convert the data reader from SQL server into a CSV file and then can export that using bulk copy.This is a very inefficient process and I was wondering if there is another way.We can't use Linked servers.

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

Popular Answer

IF you use SSIS you should be able to directly load data to an ORacle database withouthgoing through the step of creating a text file for the load. This assumes the Oracle database is availble in your network.

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