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.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment