Hello Everyone,
Is it usually faster to transfer data using DTS or over a Linked Server?
Thank you.
Scott
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
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment