---
title: "What is BCP? When does it used?"  
description: "What is BCP? When does it used?"  
author: "Anonymous User"  
published: 2014-10-12  
updated: 2020-09-20  
canonical: https://www.mindstick.com/interview/2220/what-is-bcp-when-does-it-used  
category: "mssql server"  
tags: ["database", "mssql server"]  
reading_time: 1 minute  

---

# What is BCP? When does it used?

BulkCopy is a tool used to copy huge amount of data from tables and views. BCP does not copy the structures same as source to destination. BULK INSERT command helps to import a data file into a database table or view in a user-specified format.

## Answers

### Answer by Anonymous User

BulkCopy is a tool used to copy huge amount of data from tables and views. BCP does not copy the structures same as source to destination. BULK INSERT command helps to import a data file into a database table or view in a user-specified format.


---

Original Source: https://www.mindstick.com/interview/2220/what-is-bcp-when-does-it-used

Copyright © MindStick Software Pvt. Ltd. This Markdown version is provided for developers, AI systems, and offline reading.