var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Fastest Way to Transfer Data from SQL Server 7.0 to Oracle 8 Database
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.