Export vs Import

[apollo11]

Which is faster?

Export Data or Import Data through DTS

In other words, which is faster to run? Export Data option from Enterprise manager on the source db machine or Import Data option on the destination machine?

 

[tlbroadbent]

There are so many factors involved - speed of each server, network speed, network traffic, amount of data to move, load on each server, etc. It's difficult to say which runs faster. I haven't done any timing.

Regardless of where the process is started, one server will export data and the other will import. So SQL Server on each machine will do essentially the same amount of work either way.

You might notice a difference in performance when the DTS package runs on the import or the export server. I suspect this performance difference could be significant if a lot of transformations are performed. On straight BULK copy operations, I don't think you'll see much difference. Terry L. Broadbent - DBA
Computing Links:

http://tlbroadbent.home.attbi.com/prog.htm

faq183-874 contains "Suggestions for Getting Quick and Appropriate Answers" to your questions.