Enabling FILESTREAM

[nativestranger]

Hi!

I'm wondering, is some version of FILESTREAM supported by the linux images?

Thanks!

[twright-msft]

Quick/short answer for now - no, but we are looking into what aspects of FILESTREAM we can support in the near term on Linux.

[dawiddutoit]

Hi there. I haven't been able to find out if the new sql server 2017 version has filestream and or filetables enabled. Is this the case now or is that still in the pipeline?

[twright-msft]

Filetable for sure not in SQL Server 2017 on Linux. Filestreams we are still sorting out right now for SQL Server on Linux.

[dawiddutoit]

Hi there, has this been enabled yet?

[DVG]

Just wanted to pipe in that I'm highly interested in this, and the most recent release notes for SQL Server on Linux made it seem like filestream was a thing on linux now, but trying to enable it via TSQL throws this error:

USE master
Go
EXEC sp_configure 'show advanced options'
GO
EXEC sp_configure filestream_access_level, 2
GO
RECONFIGURE WITH OVERRIDE

FILESTREAM feature could not be initialized. The operating system Administrator must enable FILESTREAM on the instance using Configuration Manager.

It didn't look like this was a enableable option in mssql-conf, so I went looking here and found this. If there is any as-yet undocumented option it would be a huge win.

[vin-yu]

Hi Everyone,

FILESTREAM for SQL Server on Linux is not yet supported. See the unsupported features section of the release notes: https://docs.microsoft.com/en-us/sql/linux/sql-server-linux-release-notes

We still have extensive testing to fully enable this feature. That said, what are your scenarios for using FILESTREAM? I would love to work with you for a temporary workaround for the time being.

[DVG]

Basically we're using it to store a big JSON blob and a few other large objects.

[twright-msft]

Would it make sense in this case to store in nvarchar(max) and/or varbinary(max)?

[jacobtobias]

Hi, has any progress been made on this issue?

[DVG]

@twright-msft From a pragmatic standpoint, probably. However these databases are set up by an internal orchestration tool that has all the DDL that has ever been run against the database, and I don't really want to fork it and maintain a 'developer edition' of the database, I'd rather it be 'just like production, save the data'

[DoCode]

@twright-msft - we use this feature in many projects on Windows to store binary files, like Azure blob storage, with the relational data. Backup and restore are very simple. Access w/ .Net very simple. We miss .NET Core support. And Linux DB support.

[Gespix]

@twright-msft - We are developping a project that stores Images (jpg, bmp, tiff, raw...). We use Sql server express edition on windows for my customers, installed on their local network. We have very fast response and no concurrency issue with this edition, and thanks to File Stream, we don't have to care about the 10Gb limitations for "nvarchar(max)" columns declared in filestream.

We have to port this project on macos, and our customers won't pay the extra cost for licensing...

[steven87vt]

Any traction on this? We are using sql server standard and want to migrate to a docker based deployment. However thats not possible if filestream is not implemented.

Is it possible to work around this by mounting a physical partition to the sql server docker container?

[jducobu]

FILESTREAM for SQL Server on Linux is not yet supported.

Is it supported now? Maybe using 2019 version?

[mauruskuehne]

We could use this feature as well. We use filestream in our application. With docker support we could simplify our internal testing infrastructure.

[akraines]

Any updates on this? I cant import our company DB on my local dev running on macOS with sql server tunning on Docker.

[steven87vt]

We eneded up switching on a param to support filestream, filesystem and s3. As time has gone on we dont ever use filestream.

Rds does not support filestream and i dont believe ms sql on Linux does either. I would suggest manually copying/deleting the file and track it using a table similar to document store.

On Wed, Sep 9, 2020, 9:33 AM akraines [email protected] wrote:

Any updates on this? I cant import our company DB on my local dev running on macOS with sql server tunning on Docker.

— You are receiving this because you commented. Reply to this email directly, view it on GitHub https://github.com/microsoft/mssql-docker/issues/47#issuecomment-689565853, or unsubscribe https://github.com/notifications/unsubscribe-auth/AEJUAEGF4PL2TXZHVYCYQCTSE57Y7ANCNFSM4DDPCSLA .

[KlissmanGranados]

Hello, the filestream is still not available? 🧐

[bertutron]

filestream is still not available?