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?
Requires Free Membership to View
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
- What do you think about this answer? E-mail us at editor@searchDatabase.com with your feedback.
- The Best Microsoft SQL Server Web Links: tips, tutorials, scripts, and more.
- The Best SQL Web Links
- Have a SQL Server tip to offer your fellow DBAs and developers? The best tips submitted will receive a cool prize. Submit your tip today!
- Ask your technical SQL Server questions -- or help out your peers by answering them -- in our live discussion forums.
- Ask the Experts yourself: Our SQL, database design, Oracle, SQL Server, DB2, metadata, object-oriented and data warehousing gurus are waiting to answer your toughest questions.
This was first published in March 2002
Join the conversationComment
Share
Comments
Results
Contribute to the conversation