Q
Problem solve Get help with specific problems with your technologies, process and projects.

BCP utility explained

What is the BCP utility. I have read that it is used for importing and exporting data, and it is much faster than the wizard. But whenever I try to use it, I am unsuccessful. Could you explain it to me with the help of one example?

In a nutshell BCP can do 2 things.
1. Take the contents of a table and turn it into a text file.
2. Take a text file and dump the data into a table.
BCP is very well documented with examples, all of the switches, etc. in Books Online.

 

For More Information

Dig Deeper on Microsoft SQL Server Installation

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchBusinessAnalytics

SearchDataCenter

SearchDataManagement

SearchAWS

SearchOracle

SearchContentManagement

SearchWindowsServer

Close