Sunday, March 11, 2012

DTS and bcp

I heard that underlying the DTS Import/export wizard is bcp.. Is that true ?
I wanted to move data between 2 servers and it seemed bcp first copies to a
file and then you can import from the file into the destination tableFile will be created in the script file directory when you copy objects and
data.
If your servers are not connected then you may want to use backup/restore or
detach/attach as a quicker transfer method.
121120120" target="_blank">http://support.microsoft.com/defaul...r />
121120120
John
"Hassan" <fatima_ja@.hotmail.com> wrote in message
news:eLID4h2UFHA.3056@.TK2MSFTNGP14.phx.gbl...
>I heard that underlying the DTS Import/export wizard is bcp.. Is that true
>?
> I wanted to move data between 2 servers and it seemed bcp first copies to
> a
> file and then you can import from the file into the destination table
>
>

No comments:

Post a Comment