Fastest Way to Transfer Data from SQL Server 7.0 to Oracle 8 Database
Trying to Do..


Transfer Data from a SQL 7 Database on NT Server via DTS job to Oracle 8iDatabase Table on another NT Server.

This Oracle 8i DB Table has no indexes.


Currently i can transfer about 8000 rows in 1 minute, i am seeking to lower this time by as much as possible


Ive also tried using ole db in dts job also, but with no significant increase in time,

Again any advice/pointers are most welcome.

BCP OUT of SQL Server and then use Oracles' IMPort tool.

I guess you could get this down to about 5 seconds...

No exp. in using Oracle's tools, but BCP is the fastest method to export rows from a database.