FILESTREAM Implementation with a Mapped Drive from LINUX

Question

Post reply

FILESTREAM Implementation with a Mapped Drive from LINUX

Reddy B

Old Hand

Points: 366
More actions
April 10, 2010 at 4:28 pm

#217731

We have WAV files in LINUX. We are planning to map a drive to the Database Server using SAMBA to LINUX to access those WAV files.
Just wondering if anybody implemented SQL Server 2008's FILESTREAM Storage using this kind of method. Just wanted to know if we are going to face any problems?
Also, wanted to know if this is even possible?
Thanks a lot in advance.

Viewing 7 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply

Nicholas Cain SSC-Dedicated Points: 33009 More actions · Answer 1

Filesteam datatypes only work on the local system, you'll not be able to use a samba share.

Shamless self promotion - read my blog http://sirsql.net

Paul White SSC Guru Points: 150468 More actions · Answer 2

Reddy B (4/10/2010)
We have WAV files in LINUX. We are planning to map a drive to the Database Server using SAMBA to LINUX to access those WAV files.
Just wondering if anybody implemented SQL Server 2008's FILESTREAM Storage using this kind of method. Just wanted to know if we are going to face any problems?
Also, wanted to know if this is even possible?
Thanks a lot in advance.

FILESTREAM requires NTFS.

See FILESTREAM White Paper

Paul White
All articles available on SQL.kiwi
@SQL_Kiwi

Reddy B Old Hand Points: 366 More actions · Answer 3

Thanks a lot for the reply.

So, using Samba Share,

Can we read the WAV file from there and INSERT into the Database (NTFS Share)?

Can we use a SP to read the WAV File from Samba Share and Insert into the Database?

Thanks in Advance.

Paul White SSC Guru Points: 150468 More actions · Answer 4

Have you read that White Paper already?! :w00t:

Paul White
All articles available on SQL.kiwi
@SQL_Kiwi

Reddy B Old Hand Points: 366 More actions · Answer 5

Hi,

I read the white paper and a lot of blogs. None of them seem to answer my specific question:

The WAV files are in a LINUX server. So, we are thinking of mapping a drive from Linux to the Database Server, in which SQL Server 2008 is installed. My idea is to Execute a SP from Linux server with the file name and read from the map drive and insert that file into the SQL Server 2008 database. We are planning to access these WAV files using our web applications from the database.

Is this possible using FILESTREAM? So far, I did not find any easy way to INSERT the WAV file into database using a Stored Procedure.

Any help will be appreciated.

sqlvogel SSCrazy Eights Points: 9526 More actions · Answer 6

The server normally only has access to physical drives and UNC paths. So if you can access your remote drive via a UNC path then yes it ought to be possible to use BULK INSERT or OPENROWSET inside a proc to insert data from a file into a column.

This has nothing to do with filestream however. As far as your procs are concerned a filestream storage column is just a VARBINARY(MAX) column. The difference is in the way it is stored and the way it can be accessed from application code.