Enable and configure filestream in azure sql db

Question

I want to store my pdf file to Azure SQL Db, and I get this error when I run create table query.

Msg 40517, Level 16, State 1, Line 28 Keyword or statement option 'file stream_on' is not supported in this version of SQL Server.

Can anyone help me how can I actually do this? 

Answer 1

Basically, FILESTREAM is not supported on Azure SQL Db. So, you can go for some alternatives to it.

Firstly, Store your whole content into in-db VARBINARY(MAX) column, this will increase your db size. and Secondly, Store your content on azure blob storage and keep the paths/url in the table, so that you can directly access blob storage via paths/url.

I hope this will work.

Want to know more about Azure Storage ? join azure certification now!