Batch files vs. BCP Commands

Question

Difference between batch files and BCP Commands???

As per my knowledge BCP(Bulk copy program) is used to load the data from flat files to database in a fast way and vice versa and batch files are used to copy the files from one location to other location, to create new directories..etc using MS-Dos commands.

Can i get exact difference between Batch files and BCP Commands??

Thanks

Venaikat

Yes, i worked with MS-Dos but only with basic commands – Venaikat Jul 08 '13 at 09:50 — Venaikat, Jul 08 '13 at 09:50

score 1 · Accepted Answer · answered Jul 08 '13 at 09:40

1

Batch files are to BCP as Java is to JavaScript

answered Jul 08 '13 at 09:40

mishik

9,973
9
45
67

And how is Java to JavaScript? – Endoro Jul 08 '13 at 09:42
so using BCP Commands we can create Batch files with .bat extension. Isn't it?? – Venaikat Jul 08 '13 at 09:59
2

How did you get that from my answer? :) – mishik Jul 08 '13 at 10:01

foxidrive · Answer 2 · 2013-07-08T11:26:07.477

BCP is a command line tool

Batch files allow you to script command line tools, to make them perform their various functions in a repetitive and reproducible way, without needing keyboard or mouse interaction.

Batch files are a general purpose programming scripting language that is interpreted, and so is slower than a compiled language, but batch scripts are generally much faster to develop a program/script to perform a task. They also have limitations when compared to many compiled languages, with poison characters etc.

Batch files vs. BCP Commands

2 Answers2