SQL Server 2012 comes with an amazing new feature called “File Tables”.
That means that you can use a file system folder as a database table with all the fun and of cause nearly all the function of a database table. You have to enable the prerequisites for FileTable (as described here: LINK) and the result is a new table in your database with the following propertys:
The columns are fixed and base on the property coming from the NTFS file system. The columns are:
Column Name
|
Data Type
|
stream_id
|
uniqueidentifier ROWGUIDCOL
|
file_stream
|
varbinary(max) FILESTREAM
|
name
|
nvarchar(255)
|
path_locator
|
hierarchyid
|
creation_time
|
datetimeoffset(7)
|
last_write_time
|
datetimeoffset(7)
|
last_access_time
|
datetimeoffset(7)
|
is_directory
|
bit
|
is_offline
|
bit
|
is_hidden
|
bit
|
is_readonly
|
bit
|
is_archive
|
bit
|
is_system
|
bit
|
is_temporary
|
bit
|
Each FileTable includes also these computed (read-only) columns:
Column Name
|
Data Type
|
parent_path_locator
|
hierarchyid
|
file_type
|
nvarchar(255)
|
cached_file_size
|
bigint
|
You can query, update, insert or delete this table the same way as a “normal” table from you database with T-SQL. You also can use a fulltextindex and so on.
So in the context of SharePoint, especially with BCS you are now able to integrate file system data in you SharePoint without writing code and without growing up you SharePoint contend database with BLOB data. You can use file system data like documents, multimedia files or whatever as a SharePoint External List, integrate it in you Search environment and using SharePoint Features like tagging, export to SharePoint Workspace and so on.
SQL 2012 File Tabel with SharePoint - for me a fantastic combination
Also check out part II of this: http://nbsharepointtalk.blogspot.de/2012/04/sql-server-2012-filestream-filetable.html
AntwortenLöschen