[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 372
  • Last Modified:

Anyone's used Filestream?

I need to upload patient information files (not huge ones, some PDF files) . I've been thinking about either using .Net's encryption to encrypt and decrypt OR use filestream here:

http://msdn.microsoft.com/en-us/library/cc645923.aspx

Anyone's used it? will I run into corrupt data and problems later when we go live? should I just C# to encrypt and load to a folder and then download and decrypt?

thanks
0
Camillia
Asked:
Camillia
  • 3
  • 2
1 Solution
 
QPRCommented:
Not sure why you would encounter corrupt data.
If you want to know about the virtues of using filestream for storage and access then you can't get better than this excellent document
http://msdn.microsoft.com/en-us/library/cc949109.aspx
0
 
CamilliaAuthor Commented:
Have you used it? as far as corrupt data...i think storing files in sql 2000 corrupted data, no?
I'm not a DBA but i remember reading about it back in the day.

Thanks for the article, let me read. Thanks
0
 
QPRCommented:
Yes within sql but not in a web/windows application.
Filestream was introduced in sql server 2008 so 2000 info must be referring to something else, perhaps BLOB.
Filestream stores the files themselves in the file system as opposed to the database.

Here are the best practises for filestream
http://www.mssqltips.com/sqlservertip/1875/best-practices-when-using-filestream-feature-of-sql-server-2008/
0
 
CamilliaAuthor Commented:
thanks again. I was able to create the filestream database. I will continue
0
 
CamilliaAuthor Commented:
it did corrupt the files. I opened a question here. Can you take a look?

http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SQL_Server_2008/Q_27665866.html
0

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now