Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


FILESTREAM Setup and Testing without Visual Studio


FILESTREAM Setup and Testing without Visual Studio

Author
Message
Hugh Thomas
Hugh Thomas
Mr or Mrs. 500
Mr or Mrs. 500 (540 reputation)Mr or Mrs. 500 (540 reputation)Mr or Mrs. 500 (540 reputation)Mr or Mrs. 500 (540 reputation)Mr or Mrs. 500 (540 reputation)Mr or Mrs. 500 (540 reputation)Mr or Mrs. 500 (540 reputation)Mr or Mrs. 500 (540 reputation)

Group: General Forum Members
Points: 540 Visits: 57
Comments posted to this topic are about the item FILESTREAM Setup and Testing without Visual Studio



Adam Seniuk
Adam Seniuk
Mr or Mrs. 500
Mr or Mrs. 500 (596 reputation)Mr or Mrs. 500 (596 reputation)Mr or Mrs. 500 (596 reputation)Mr or Mrs. 500 (596 reputation)Mr or Mrs. 500 (596 reputation)Mr or Mrs. 500 (596 reputation)Mr or Mrs. 500 (596 reputation)Mr or Mrs. 500 (596 reputation)

Group: General Forum Members
Points: 596 Visits: 1040
Great post, I was wondering how to setup FILESTREAM without the need of Visual Studio.

One item I wasn't sure of was how is the file system security handled, since the file isn't encrypted.


Over 12yrs in IT and 10yrs happily stuck with SQL.

http://aseniuk.wordpress.com
- SQL 2008/R2/2012/2014
- Oracle 8/9/10/11
- MySQL 4/5
Hugh Thomas
Hugh Thomas
Mr or Mrs. 500
Mr or Mrs. 500 (540 reputation)Mr or Mrs. 500 (540 reputation)Mr or Mrs. 500 (540 reputation)Mr or Mrs. 500 (540 reputation)Mr or Mrs. 500 (540 reputation)Mr or Mrs. 500 (540 reputation)Mr or Mrs. 500 (540 reputation)Mr or Mrs. 500 (540 reputation)

Group: General Forum Members
Points: 540 Visits: 57
One item I wasn't sure of was how is the file system security handled, since the file isn't encrypted.


Ravi S. Maniam mentions this in his blog post on Filestream. Looks like the physical files should just be available, from an NTFS security perspecitive, by the account that the SQL service is running under. Because my testing was done in a sandbox where the SQL service account did match my windows login account, it wasn't an issue for me when I opened my test file.

If you try to open the test file and are denied, this would be the reason. Sounds like a pretty decent security scheme as long as admins don't run around adding permissions to the filestream folder.



a.rajmane
a.rajmane
SSC Rookie
SSC Rookie (37 reputation)SSC Rookie (37 reputation)SSC Rookie (37 reputation)SSC Rookie (37 reputation)SSC Rookie (37 reputation)SSC Rookie (37 reputation)SSC Rookie (37 reputation)SSC Rookie (37 reputation)

Group: General Forum Members
Points: 37 Visits: 40
Will enabling filestream help if its not a BLOB?
Hugh Thomas
Hugh Thomas
Mr or Mrs. 500
Mr or Mrs. 500 (540 reputation)Mr or Mrs. 500 (540 reputation)Mr or Mrs. 500 (540 reputation)Mr or Mrs. 500 (540 reputation)Mr or Mrs. 500 (540 reputation)Mr or Mrs. 500 (540 reputation)Mr or Mrs. 500 (540 reputation)Mr or Mrs. 500 (540 reputation)

Group: General Forum Members
Points: 540 Visits: 57
a.rajmane (9/3/2009)
Will enabling filestream help if its not a BLOB?


I'm not sure exactly what you mean, but I will try to clarify in hopes that it answers your question.

In a traditional varbinary(MAX) field without FILESTREAM, the data is stored as a blob in the database. With FILESTREAM, the binary data is stored in the file system as an actual file, of any type. It could be a MS Word document, image file, PDF, or most any other type regular file. Therefore, whatever methods are available through ASP.NET, T-SQL, etc. to import or retrieve the data, the core data is an actual file where the database is simply storing a pointer to that file.

I hope that helps.



ChiragNS
ChiragNS
SSCrazy
SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)

Group: General Forum Members
Points: 2899 Visits: 1865
While creating the table to store filestream data you have specified the filestream file group with the keyword "FILESTREAM_ON". Is it necessary because i did not find the same in BOL.

-- Create the test table for FILESTREAM
CREATE TABLE [dbo].[tFileStreamTest](
[id] [int] IDENTITY(1,1) NOT NULL,
[FileStreamTest] [varbinary](max) FILESTREAM NULL,
[FileGUID] UNIQUEIDENTIFIER NOT NULL ROWGUIDCOL
UNIQUE DEFAULT NEWID()
) ON [PRIMARY]
FILESTREAM_ON [FileStreamGroup1];
GO



"Keep Trying"
mchou
mchou
Forum Newbie
Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)

Group: General Forum Members
Points: 6 Visits: 24
Hi,

I follow your step-by-step process, however, I got "FILESTREAM feature is disabled" error at "Add Filestream Filegroup to db" step. I am little bit confused about this error msg because I did configure/reconfigure at step 1 as you described in the doc. Any tips? Thanks.



herman-991596
herman-991596
Forum Newbie
Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)

Group: General Forum Members
Points: 2 Visits: 22
Very good article. It works.
I have a database for my wine inventory and i added filestream columns to store information for a particular wine (info from websites and other documents (jpg, pdf).

I can store the documents with filestream. Great!
But how can i show that info via sql or via MS Access which is still my frontend for maintaining my database?

(I maintain de filestream info manually via a stored procedure, because i don't see a possibility via MS Access)

THANKS!
Hugh Thomas
Hugh Thomas
Mr or Mrs. 500
Mr or Mrs. 500 (540 reputation)Mr or Mrs. 500 (540 reputation)Mr or Mrs. 500 (540 reputation)Mr or Mrs. 500 (540 reputation)Mr or Mrs. 500 (540 reputation)Mr or Mrs. 500 (540 reputation)Mr or Mrs. 500 (540 reputation)Mr or Mrs. 500 (540 reputation)

Group: General Forum Members
Points: 540 Visits: 57
Chirag (9/3/2009)
While creating the table to store filestream data you have specified the filestream file group with the keyword "FILESTREAM_ON". Is it necessary because i did not find the same in BOL.

-- Create the test table for FILESTREAM
CREATE TABLE [dbo].[tFileStreamTest](
[id] [int] IDENTITY(1,1) NOT NULL,
[FileStreamTest] [varbinary](max) FILESTREAM NULL,
[FileGUID] UNIQUEIDENTIFIER NOT NULL ROWGUIDCOL
UNIQUE DEFAULT NEWID()
) ON [PRIMARY]
FILESTREAM_ON [FileStreamGroup1];
GO



This is only required for partitioned tables as described here. Search for the text "If the table contains FILESTREAM data and the table is partitioned" to find the section that explains. Sorry for the confusion.



Anipaul
Anipaul
SSCertifiable
SSCertifiable (6.8K reputation)SSCertifiable (6.8K reputation)SSCertifiable (6.8K reputation)SSCertifiable (6.8K reputation)SSCertifiable (6.8K reputation)SSCertifiable (6.8K reputation)SSCertifiable (6.8K reputation)SSCertifiable (6.8K reputation)

Group: General Forum Members
Points: 6813 Visits: 1407
Nice Post. Good one..



Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search