DTS vs bcp - Which is Faster (server speed???)

[hmohrmann]

Problem: move files from sql2000 server S1 to sql2000 S2 the fastest way possible. S1 is 4 times faster than S2.
Which is faster:
1. DTS on S1 to push to S2
2. DTS on S2 to pull from S1
3. bcp on S1 to push to S2
4. bcp on S2 to pull from S1
According to Microsoft a bcp doing export is 3 to 6 times faster than DTS.
see:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dtssql/dts_usage_7703.asp

So is number 4 the fastest? Does any one know?

 

[MDXer]

BCP OUT on S1 and BCP IN on S2. would probably be the quickest.

"Shoot Me! Shoot Me NOW!!!"
- Daffy Duck