Bulk Copy Program (bcp)

If SSIS is your friend and mine, then The Bulk Copy Program, or bcp, would be that old friend that we
may not see that much any more, but really appreciate when we do.
bcp is a command-line program that’s sole purpose in life is to move formatted data in and out of SQL
Server en masse. It was around long before what has now become SSIS was thought of, and while SSIS
is replacing bcp for most import/export activity, bcp still has a certain appeal for people who like
command-line utilities. In addition, you’ll find an awful lot of SQL Server installations out there that
still depend on bcp to move data around fast.

Twitter Widgets Facebook Widgets

For Further Reading:

Leave a Comment

Previous post:

Next post: