A BCP GUI

Due to the excessive amount of BCP work that has plagued me recently, I was sick and tired of typing.
Instead of writing a script in TSQL to build BCP commands, I decided on building a little GUI app.

I have tried to constrain the interface to only allow valid BCP argument combinations, but again due to laziness, I have not tested them all. If the BCP command appears to be doing nothing, you have the option to KILL the process.

Features:

  • Easy to use. (should be!)
  • Tool tips for each switch are taken from BOL
  • Batch option for building (not executing) multiple BCP commands ie. An entire database
  • Automatically redirects output to a temporary file for viewing the results.
  • Integrated File Viewer to look a the first 2MB of a file (needs improvement though)..
  • Monitors file growth of the target data file (OUT modes) or output file (IN mode)
Here's a picture of the main screen..
BCP Helper

I am hoping that this application needs no help file or manual, as it is targeted at developers who at least know what BCP is...

The entry point to this app accepts a parameterless constructor (when you simply open it), or a server name. The second constructor allows us to integrate it into the "Tools" menu in QA.

To integrate this into QA..

  1. Select "Tools".."Customise" from the main menu of QA
  2. Select the "Tools" tab
  3. Press the "Add" button
  4. Enter the Display Name
  5. Fill out the "Command" by browsing to the BCPHelper file
  6. Fill out the "Argument" section with the word $(Server).
If you have completed it correctly it should look something like this...
QA Integration

Now when you select "Tools" from QA, you should see the BCP Helper application.
When you launch the app from QA, it will take the current server and populate the text box.

You will need the .NET framework v1.0 or higher to run this
Oh now there is a bitch..How on earth did MS miss the FolderBrowser Dialog control in 1.0 framework!!!!

Installation is just a matter of extracting the file
This link is the zipped file (22Kb) at SQLTeam. BCPHelper.zip

A special thank you to Damian for uploading the file and for giving some feedback. Also to Rob and Graz for some testing and hosting this...

All comments are welcome, and please report any bugs! Enjoy...

Print | posted on Wednesday, March 31, 2004 1:13 PM

Feedback

# re: A BCP GUI

left by Justin at 3/31/2004 2:19 PM Gravatar
Very nice! It's like this tool was custom built for me, I do know what bcp is, but I'm too lazy to commit all the options to memory. :)

# re: A BCP GUI

left by DavidM at 3/31/2004 2:31 PM Gravatar
Thank you muchly!

I must admit that by building this thing, I now know all the switches! I'll have to drink alot to erase them...

# re: A BCP GUI

left by Jay at 3/31/2004 10:30 PM Gravatar
Nice !!!!!

# A BCP GUI

left by andrew connell at 3/31/2004 8:35 AM Gravatar

# A BCP GUI

left by andrew connell at 3/31/2004 8:48 AM Gravatar

# re: A BCP GUI

left by Greg at 4/1/2004 1:05 AM Gravatar
Very nice...

# re: A BCP GUI

left by Todd B at 4/1/2004 8:12 AM Gravatar
Thanks. :)

# Give me a GUI

left by InnerGeek at 3/31/2004 6:18 PM Gravatar
This looks like it could be very useful. BCP is a command-line tool to do data dumps to and from data files. The tool David has built puts a GUI on top. Cool!...

# re: A BCP GUI

left by Jeff at 4/1/2004 10:12 AM Gravatar
David -- this looks excellent !!! very well done !

# BCP GUI

left by Enigma at 4/1/2004 1:13 AM Gravatar
BCP GUI

# re: A BCP GUI

left by DavidM at 4/1/2004 4:55 PM Gravatar
Thank you very much Jeff! Any improvements/functionality you would like to see?

# re: A BCP GUI

left by Yoshihiro Kawabata at 4/2/2004 12:40 PM Gravatar
Cool !
So, I want to translate to Japanese.
Dose it support Culture resource .resx ?

# BCPHelper BCPを簡単に実行できるツール

left by 河端善博の .TEXT でウェブログ at 4/1/2004 11:35 PM Gravatar
BCPHelper BCP????????????

# re: A BCP GUI

left by Jeff at 4/3/2004 12:17 AM Gravatar
David -- the only "feature" missing is the "shareware nag screen" !

It looks very professional and complete ... but admittedly, I am not a BCP regular user so I haven't tried all the features yet.

# re: A BCP GUI

left by x002548 at 4/3/2004 2:48 AM Gravatar
Just make sure you don't call it with xp_cmdshell 8-)

# re: A BCP GUI

left by George at 7/16/2004 11:15 PM Gravatar
I'm just currious ´how the connection strin gshould look? Do I need to specify more than just the IP and port to the db server?

Thanks

# re: A BCP GUI

left by -bda- at 8/13/2004 7:30 PM Gravatar
Very nice and useful !!! Thanks.

# re: A BCP GUI

left by Adrian Banas' at 8/26/2004 1:45 PM Gravatar
This is just what I have been looking for over the past two days. OUTSTANDING!!!!!!! Now, if you could only add in conversion from Mainframe to ASCII - Adrian

# BCP Helper v 1.2

left by .NET Tools Blog at 8/27/2004 7:09 AM Gravatar

# re: A BCP GUI

left by Andres at 6/8/2005 2:02 AM Gravatar
test

# re: A BCP GUI

left by saket at 6/16/2005 10:11 PM Gravatar
good work

# re: A BCP GUI

left by Kevin Zhang at 7/12/2005 3:24 PM Gravatar
Excellent! It's a nice tool.

# re: A BCP GUI

left by Chris Colbert at 9/14/2005 7:58 AM Gravatar
Thx. Nice job and big help to me since I am used to Oracle and sqlloader. I don't know how many instances (I haven't tried to open more than 4) you want to allow the user to open so you might want to add a check on that. Also, once the script is executed from the app you might want to make the tmp file view a response window and place a command button on it. Heck, not that it matters though works fine and I think most of us who would use this tool would probably know better than to open a dozen instances and we know how to close a window. Thanks for taking the time to do it.

# re: A BCP GUI

left by Aneesh at 10/17/2005 10:47 PM Gravatar
I got an Application error while running it
'failed to initiate'

# Table Sort Order

left by Harley Green at 3/16/2007 4:05 AM Gravatar
Very nice! Thank you.

One enhancement that would be great - have the tables sorted by name.

# re: A BCP GUI

left by Stephen at 4/10/2007 6:43 AM Gravatar
Great tool. I used it once and fell in love. Easy to use and a great learning tool.

# re: A BCP GUI

left by Paperless at 10/4/2007 5:59 AM Gravatar
I found your utility easy to use and was able to execute a bcp generated with your utility that produced the desired output file.
Unfortunately, when I placed the code in a stored procedure used by Crystal reports, the code fails to output to a mapped drive on the network. However it outputs fine when it points to the local C: drive. Any clue as to what could be going on? (Crystal Reports is using an ODBC driver for SQL.)

# re: A BCP GUI

left by Wayne at 5/24/2008 8:02 AM Gravatar
Thanks! This just saved me days of work.

# re: A BCP GUI

left by JG at 11/22/2008 9:54 AM Gravatar
DUDE DUDE DUDE I Love you DUDE U Rock. O my god u rock. I need this thing so bad. . . Thanks a million. I'll chill out now but thanks for making this accessible!!

# re: A BCP GUI

left by Dave at 2/19/2009 10:04 PM Gravatar
Very helpful for us - thanks.

# re: A BCP GUI

left by Michelle C at 2/24/2009 5:58 AM Gravatar
I cant this to run with sql server 2005. I keep getting an error "Unable to open BCP host data-file". Any suggestions?

Thanks,
Michelle

# re: A BCP GUI

left by Marc at 3/27/2009 1:33 AM Gravatar
First let me say great tool, now I don’t have to memorize all the BCP switches! Have you ever thought of sharing the source code or going open source? The environment I work in has several different database engines (Oracle, Sybase and MS SQL server) so the batch output your tool creates doesn't work without some tweaks. I think this is a great start and with a few changes could work in my environment well.

# re: A BCP GUI

left by pete a at 10/6/2009 1:29 AM Gravatar
Wanted to run via master..xp_cmdShell - that seems to not be working. any ideas
Comments have been closed on this topic.