What is BCP? and how or when is it used?

All topics about programming / development in T-SQL or other languages for SQL Server.
Post Reply
Codebert
Posts: 2
Joined: Tue Jul 02, 2019 7:22 pm

Tue Jul 02, 2019 7:26 pm

As the subject says, what is a BCP?

Many thanks
Laura1996
Posts: 17
Joined: Thu Jun 20, 2019 6:41 pm

Tue Jul 02, 2019 7:29 pm

Hi @Codebert

A BCP (Bulk copy program) is a tool that is used to copy large amounts of data from tables /views.
BCP can be used to import large numbers of rows into SQL Server or export SQL Server data into files. The BCP data files don’t include any schema details or format information. Hence, it is recommended to create a format file to record the data format so in case of any failures, you can refer to the format file and better understand the data format to determine what may have gone wrong.
Post Reply

Social Media