MS SQL Server - DTS Versus Linked Servers

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

DTS Versus Linked Servers

Scott Yu

2006-11-16, 7:12 pm

Hello Everyone,

Is it usually faster to transfer data using DTS or over a Linked Server?

Thank you.
Scott

Edgardo Valdez, MCTS, MCITP, MCSD, MCDBA

2006-11-16, 7:12 pm

It all depends on what are you transferring. In my experience:

-. For small number of records and ad-hoc transfers, linked server does the
trick
-. For import jobs with transformation, extraction and load, that need to be
performed regularly, DTS may be your candidate
-. For massive amount of data to be transferrend to single tables, BCP out
to text files and BCP in to the target server is faster than linked server or
DTS.

"Scott Yu" wrote:

> Hello Everyone,
>
> Is it usually faster to transfer data using DTS or over a Linked Server?
>
> Thank you.
> Scott

Sponsored Links