0

We are migrating our existing client databases to Azure soon. Our current database uses FileStream and has some data stored in columns of type varbinary(max). From what I have read, FileStream is not supported in Azure.

How would we be able to migrate this data to Azure? Hopefully this isn't repeat, but I have not been able to find an example of someone doing this.

1 Answer 1

1

It is not supported in Azure SQL Databases, but you have two other options. One is to simply use a VM with a SQL Server installed and the other one, and recommended, is to use the newly announced SQL Server Managed Instances.

https://azure.microsoft.com/en-us/blog/migrate-your-databases-to-a-fully-managed-service-with-azure-sql-database-managed-instance/

2
  • But can we use Azure Storage for SQL Server FileStream? If so, how? Jun 19, 2018 at 18:07
  • 1
    Based on Filestream and Filetable limitations in Azure SQL Database Managed Instance, it would appear not.
    – Mark G
    Oct 5, 2018 at 16:42

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.