Uploading pdf files from a Folder to SQL Server RRS feed

  • Question

  • Hi All,

    We have to upload .PDF files (>30GB data) from a shared location to SQL Server.

    Some files are of 80MB.

    What is the best / optimal way for doing this using .net code?




    Friday, October 25, 2013 11:31 AM


  • Hi David_7,

    Personally, I will suggest you to think about whether the files need to be stored in SQL server. How about just store the path of it?

    If the file is large than 1M, and frenguently need to be read and written, it seems that store the path instead of file will be suitable. Here is an article to talk about this issue, and you can read it:

    To BLOB or Not To BLOB: Large Object Storage in a Database or a Filesystem: http://research.microsoft.com/apps/pubs/default.aspx?id=64525

    If you insist to add the file into the database, please refer to this article :

    Uploading and downloading files to/from a SQL Server database: http://www.codeproject.com/Articles/225446/Uploading-and-downloading-files-to-from-a-SQL-Serv

    We are trying to better understand customer views on social support experience, so your participation in this interview project would be greatly appreciated if you have time. Thanks for helping make community forums a great place.
    Click HERE to participate the survey.

    • Proposed as answer by Prabha, Sydney Monday, October 28, 2013 3:52 AM
    • Marked as answer by David_7 Monday, October 28, 2013 4:29 PM
    Monday, October 28, 2013 2:43 AM

All replies