Solved

ASP.net and SQL Upload documents for storage

Posted on 2013-06-03
2
190 Views
Last Modified: 2013-06-07
Hi

I am building an ASP.net site where the users will upload documents (Word, Excel, PDF etc) that need to be stored. Is the best place to store these in the SQL database or should I store them in a folder? How would I build this? Just need a few pointers?

Thanks
0
Comment
Question by:murbro
2 Comments
 
LVL 7

Accepted Solution

by:
aplusexpert earned 500 total points
ID: 39215980
Hi murbro,

I think If your server is only at one place (means it is not shared hosting or you need to move on another machine) then you should store file in the database. And if it stays on one machine (means you owned your own server) then you should store files to your machine and only need to store your file path in the database.

Thanks.
0
 

Author Closing Comment

by:murbro
ID: 39228432
Thanks
0

Featured Post

Back Up Your Microsoft Windows Server®

Back up all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

JSON is being used more and more, besides XML, and you surely wanted to parse the data out into SQL instead of doing it in some Javascript. The below function in SQL Server can do the job for you, returning a quick table with the parsed data.
The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
Via a live example, show how to shrink a transaction log file down to a reasonable size.
Viewers will learn how the fundamental information of how to create a table.

777 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question