Use Azure blob storage as SQL Server Filestream provider in Azure SQL(Paas)

Question

How do we move from SQL Server onpremise database using Filestream to Azure SQL(Paas)?

Answer 1

Hi,

Filestream is not supported on Azure SQL Database. You might want to have a look at Azure SQL Managed Instance.

Answer 2

Hi @Maulik Modi

Limitations
In the current release of this feature, storing FileStream data in Azure Storage is not supported. You can store FileStream data in a database that also contains data files stored in Azure Storage, but all FileStream data files must be stored on local storage. Since the FileStream data must reside on local storage, it cannot be moved between machines using Azure Storage, therefore we recommend that you continue using the traditional techniques to move the data associated with FileStream between different machines.

Technical reason
Because of its nature PaaS. So, in case you do not want to change anything in your SQL Databases, you can consider to use Azure SQL Managed Instance. If you are using your filestream to just query your data, you can use the varbinary type instead of filestream on your table's columns. To migrate your SQL Databases to Azure SQL Managed Instance, please have a look to this article.

refer - Best alternative to SQL Server Filestream on Azure SQL service

If a post helps to resolve your issue, please click the Accept the answer and Click Answered Vote as helpful . By marking a post as Answered and/or Helpful, you help others find the answer faster.