What is BCP utility in SQL SERVER?
The Bulk Copy Program (BCP) is a command line utility by which you can import & export large amounts of data in and out of the SQL SERVER database.
The sample below shows the BCP in action.
Figure :-Export BCP utility in action
Figure :-Import BCP utility in action