Filestream or Filetable..what should be used?

  • Feivel

    SSCertifiable

    Points: 7518

    I've been assigned with a project that includes converting the columns in the existing tables to use FileTable or Filestream. Basically, the requirement is to move blob fields to filetable storage if possible. Columns that matters are XSLT, XMLData, and Results from ExportRunResults table and there is a UserFiles table that has a column FileData that also needs to undergo the same process. I have attached the schema files for both and how the data looks like in the screenshots. I would like to know if it is feasible to convert the existing columns and tables to use Filetable or Filestream and instead of having the values stored inside the tables we can use either technologies to store files in the file system and pointers in the table. All these files could be .pdf, jpg etc.

    Appreciate any help on this as I haven't found any useful article that would help achieve the task in my scenario.

    • This topic was modified 1 month, 1 week ago by  Feivel.
    • This topic was modified 1 month, 1 week ago by  Feivel.
    Attachments:
    You must be logged in to view attached files.
  • Site Owners

    SSC Guru

    Points: 80376

    Thanks for posting your issue and hopefully someone will answer soon.

    This is an automated bump to increase visibility of your question.

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

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