![]() SQL Server 2012 enhanced FileStream even further by introducing FileTable feature. The storage of the unstructured data in FileStream improves the performance by leveraging the NTFS APIs streaming along with additional benefits of the database system. This feature is used for storing unstructured data, such as word documents, presentations, videos, audios and images on the file system with a pointer to that data in the database. The FileStream feature was introduced within SQL Server 2008. ![]() What is FileStream and FileTable and what can we do with them? We, at ⋮IWConnect use this extension to help our clients develop more accessible and practical database solutions where they will get optimal solution for storing files. The new approach can offer a lot, starting from having metadata when the user stored the file, the type of it, the last time it was updated, the last time it was accessed and much more.įileTable, an extension of FileStream feature as part of Microsoft SQL Server offers all of the aforementioned solutions. Therefore we can have better and optimized applications that store data appropriately. In this case, Microsoft offers the best solution by combining the most adequate features of both of them. So, historically speaking the most popular ways for doing that were:ġ) storing the file in a database as a binary large object (BLOB), andĢ) storing a network path in the database while the files are stored somewhere in the file system.īoth approaches are good, but they are two, not only one approach that will comprise all of the aforementioned features. In the past, there had been attempts to do that and even some solutions. Very often, we might encounter the problem of establishing a solution which stores files, but on the other side the database size is increasing rapidly or the files are not accessible on the network path they were supposed to be stored on. The ability to store files and to connect them to other important information from a database solution is an important advantage both for the technical engineer and the company. FebruHow to store files in SQL Server Database without increasing its size or losing a link to it?
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |