Post reply

Data Type - external file storage?

  • March 19, 2012 at 7:34 am

    #270382

    Hi all,

    I hope you can help me.

    I believe that SQL Server 2008 (or R2) introduced a data type for storing LOBS/BLOBS outside of the database (on a file server for example).

    We have an upcoming requirement to store images of people in a database and I'm looking for the best way to recommend.

    I've looked in BOL under things like "LOB Data type" but haven't hit it so far.

    It is an OLTP database, but fairly small (approx 230,000 person records) and reasonably low volume of updates, but still... I'd like to know the best way to store an image with each record. If it is, in fact, to create an 'image' column and store the picture inline with the table, then so be it.

    Any advice is very much appreciated!

    Steve

  • March 19, 2012 at 7:39 am

    #1461125

    use filestream feature is best option for your requirement.

    http://technet.microsoft.com/en-us/library/bb933993.aspx

  • March 19, 2012 at 7:47 am

    #1461126

    Thanks!

    That's what I was looking for.

    Much appreciated.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply