Search code examples
sql-serverasp.net-mvcfilestreamfilegroup

Storing images in a Sql Server 2008 database using Filegroups/Filestreams


Has anyone had an experience storing user uploaded images in a MSSQL 2008 Database using Filegroups and Filestreams? I read a few articles that seemed to say they are a good idea because you get all the advantages of storing images on disk and in the db. For example

I have implemented this for my current project but it seems like I'm doing a lot of unnecessary work having to convert the bytes and writing them as an image. (I'm using ASP.Net MVC)

Are there any other gotchas I should be worrying about? Should I really being storing these images on the disk myself instead? Should I look into other alternatives such as Amazon AWS?


Solution

  • I ended up using Azure Blog Storage. It works great for image storage!