Database managed file system

Question

Our Silverlight web application allows users to open and save files to the cloud. The file system is managed using SQL Sever 2008 and the FILESTREAM type. We are looking at moving the whole system including the database onto Azure. However it appears that SQL Azure doesn't support the FILESTREAM type. How would we provision this using Blob Storage, managed by the database?

Answer 1

Hi,

You have to change the app. In the cloud you manage storing files and Shared Access Signatures creation at application level. In the database you now store the file's url. SQL Database doesn't talk directly to Blob Storage.

---

If you found this post useful, Please "Mark as Answer" or "Vote as Helpful". Best Regards.

Answer 2

Hi,

Yes, sql azure doesn't support the FILESTREAM. It would be a change in your application design if you want file storage. As suggested by @Vitor you can use shared access signatures with blob storage.

If you dont want any changes to your code and want to migrate as is, the other option is you can use azure VM with SQL on it. With that you need not change any thing and you can migrate you DB as is and get all the features that you are getting today with on premise.

But you will have to manage the VMs and DB backups etc.. Hardware related failovers azure platform will take care automatically.

Please let me know if you need any additonal details on that option.

---

Please mark the replies as Answered if they help and Vote if you found them helpful.

Answer 3

I kind of thought this would be the answer, just needed to hear it. Thanks anyway!