Mssql-docker: filestream supporting in sql server 2019 on linux

[nikkhoo63]

Hi
I want to restore a backup of database with filestream into sql server 2019 preview in ubuntu.
but when I restore the database this error received:
The path '/var/opt/mssql/data/dbname_FileStream' cannot be used for FILESTREAM files. For information about supported paths, see SQL Server Books Online.
according to this I know this feature on linux not supported in mssql 2017 but there is no mention of this feature in sql server 2019 preview.
I want to know sql server 2019 will support this feature on linux?
if not supported is another solution to solve this problem?
thanks

[amitmsft]

We do not have support for filestream for SQL Server 2019. Please file a feedback item here for this feature. If you are looking to store files and access them using SQL Server Linux containers, then you could evaluate HDFS storage capabilities with SQL Server 2019 Big Data Clusters.

[jducobu]

@amitmsft, do you mean FILESTREAM is now replaced by SQL Server 2019 Big Data Clusters?

[amitmsft]

Filestream is not replaced with Big Data Cluster. Big Data Cluster lets you fulfil the same scenario and is going to be available in SQL Server 2019 RTM, hence the ask to evaluate Big Data Cluster if you need similar capability with SQL Server on Linux.

[JohnGalt1717]

This is a major blocker for a lot of companies with filestreams. Really need to be able to get this working in SQL Server for linux and docker.

[unicorn667]

any news? i can´t find nothing about this topic in what´s new document

https://docs.microsoft.com/en-us/sql/sql-server/what-s-new-in-sql-server-ver15?view=sql-server-ver15

[tedivm]

Well this is annoying- having support for this would definitely help our developers.

[srNext]

We evaluated running SQL Server 2019 on Linux (and containers, particularly for the dev environment) as we are about to upgrade from 2017, since all our other servers are already on Linux anyway.
Only to find out that filestream/filetable are not supported on Linux....
This is a major blocker for us and as such we will have to stick with a single Windows machine once again for the database, just because of this one thing. I agree with @JohnGalt1717 that you really need to get this working on Linux and Docker. Been over a year since and no change on this matter.

[RichardHubertPtw]

A quick status on this would be appreciated. We cannot expect our customers (standard IT-centers worldwide) to install a BigDataCluster just to support one application. As such, the suggestion above is not feasible for most.

[ArthurBorsboom]

A gentle ping on the status of filestream for MSSQL for linux.

[bNobo]

If you really need this feature you can vote for it here : https://feedback.azure.com/forums/908035-sql-server/suggestions/38269312-filestream-and-filetable-for-sql-server-2019-linux