DTS Vs BCP/Bulk Insert - What to use?

Hi,
I have around 13 million records in a table on Server A. I need to port this
data to Server B over the network (LAN).
Would it be better for me to BCP out the tables first in Server A and then
zip and copy it to Server B and then BULK INSERT it, or would it be better t
o
run the DTS import/export utility? Which would be faster?
Both installations are SQL Server 2000 with SP 3a, and both have nearly the
same hardware configs.
Thank you.
Regards,
KarthikHi
I would probably go for the BCP option, speed could be affected in several
ways, and you may want to drop indexes before importing and re-create them
afterwards, you may also want to change the recovery mode to simple during
the operation. Another approach would be to restore a backup and select into
on the same server.
John
"Karthik" wrote:

> Hi,
> I have around 13 million records in a table on Server A. I need to port th
is
> data to Server B over the network (LAN).
> Would it be better for me to BCP out the tables first in Server A and then
> zip and copy it to Server B and then BULK INSERT it, or would it be better
to
> run the DTS import/export utility? Which would be faster?
> Both installations are SQL Server 2000 with SP 3a, and both have nearly th
e
> same hardware configs.
> Thank you.
> Regards,
> Karthik|||BULK insert is faster
Karthik wrote:
> Hi,
> I have around 13 million records in a table on Server A. I need to port th
is
> data to Server B over the network (LAN).
> Would it be better for me to BCP out the tables first in Server A and then
> zip and copy it to Server B and then BULK INSERT it, or would it be better
to
> run the DTS import/export utility? Which would be faster?
> Both installations are SQL Server 2000 with SP 3a, and both have nearly th
e
> same hardware configs.
> Thank you.
> Regards,
> Karthik|||Hi John,
Thank you for the clarification.
I have already dropped the indexes and changed the recovery model to simple.
Just out of curiosity, why would the DTS import/export wizard be slow?
Regards,
Karthik
"John Bell" wrote:
[vbcol=seagreen]
> Hi
> I would probably go for the BCP option, speed could be affected in several
> ways, and you may want to drop indexes before importing and re-create them
> afterwards, you may also want to change the recovery mode to simple during
> the operation. Another approach would be to restore a backup and select in
to
> on the same server.
> John
> "Karthik" wrote:
>|||Hi
I would mainly use BCP out of preference as I think there is more control,
than the wizards. Also having worked with older versions of SQL Server it
would have been the only way to have done it in the past!
John
"Karthik" wrote:
[vbcol=seagreen]
> Hi John,
> Thank you for the clarification.
> I have already dropped the indexes and changed the recovery model to simpl
e.
> Just out of curiosity, why would the DTS import/export wizard be slow?
> Regards,
> Karthik
> "John Bell" wrote:
>