Aug 03, 2018 07:22 AM|eralper|LINK
To manage binary data on SQL Server the easiest way is to keep it in
FileTables are exposed to use of others just like a Windows File folder so you can simply drag and drop images into those files.
By enabling FileStream feature of SQL Server the FileTable can be reachable in a folder under the default network share for that instance FileStream
Additionally, backup and restore operations of the image files are managed like data of your database seemlessly at the same time. This eliminates the loss of images kept in file folders on the other hand data is in database. Developers can miss the synchronization
in previous methods.
But with used of FileStream and FileTables actually the images you see on the FileStream folders are actually kept in special database tables FileTable