asked on

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

ASKER CERTIFIED SOLUTION

QPR

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Camillia

ASKER

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

QPR

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/

Camillia

ASKER

thanks again. I was able to create the filestream database. I will continue

Camillia

ASKER

it did corrupt the files. I opened a question here. Can you take a look?

https://www.experts-exchange.com/questions/27665866/Filestream-corrupts-files-I-know-the-issue-dont-know-where-to-fix.html