title: SQLBulkCopy or Bulk Insert
body: <p>I have about 6500 files for a sum of about 17 GB of data, and this is the first time that I've had to move what I would call a large amount of data.  The data is on a network drive, but the individual files are relatively small (max 7 MB).  </p>
  
  <p>I'm writing a program in C#, and I was wondering if I would notice a significant difference in performance if I used BULK INSERT instead of SQLBulkCopy.  The table on the server also has an extra column, so if I use BULK INSERT I'll have to use a format file and then run an UPDATE for each row.</p>
  
  <p>I'm new to forums, so if there was a better way to ask this question feel free to mention that as well.</p>