From the course: Designing Database Solutions for SQL Server 2016
Unlock the full course today
Join today to access over 23,300 courses taught by industry experts.
Store FILESTREAM and FileTable data - SQL Server Tutorial
From the course: Designing Database Solutions for SQL Server 2016
Store FILESTREAM and FileTable data
- If your database design calls for the immigration of files such as audio, images or other document types, then you'll want to investigate the SQL Server feature called Filestream. In the past, immigrating a database with unstructured binary data files meant providing links to their location on the disk drive. This is not an ideal solution since the database cannot manage those files adequately. It can't create backups or prevent alterations made by external programs. An alternative option brought the binary data directly into a SQL Server table using the varbinary(max) field. This allows the database to manage the file but makes accessing it from external applications difficult while simultaneously bloating the size of the database and hogging resources. This is where Filestream comes into play. When Filestream is implemented on a database, varbinary(max) columns use the file system for storage while SQL Server still maintains the ability to manage other attributes of the file. It…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.