What is BCP? When is it used?
The Bulk Copy Program (BCP), as the name suggests is used to import or export large amount of data from a database. Some uses of BCP are:
- Export data in Bulk from a server into a data file.
- Export data in data from a query.
- Import data in Bulk from a file to the server.
- Used to generate format of files.