Stack Overflow
Stack Overflow

Questions tagged [filetable]

FileTable helps integrate SQL Server Databases with FileSystem storage by leveraging existing FILESTREAM capabilities.

The FileTable feature brings support for the Windows file namespace and compatibility with Windows applications to the file data stored in SQL Server. FileTable lets an application integrate its storage and data management components, and provides integrated SQL Server services - including full-text search and semantic search - over unstructured data and metadata.

In other words, you can store files and documents in special tables in SQL Server called FileTables, but access them from Windows applications as if they were stored in the file system, without making any changes to your client applications.

The FileTable feature builds on top of SQL Server FILESTREAM technology. Notably, FileTable allows non-transactional access to the files, something not possible with FILESTREAM.

130 questions
2
votes
1 answer

.NET core support for SqlFileStream or any alternative way to get a filestream out of SQL Server using C#?

I noticed SqlFileStream is not supported in .NET Core. But then read it might be available in 3.0? I have some sample code in .NET classic. Basically I am trying to get the data somehow from a SQL command in C# to a filestream that I can copy to…
punkouter
  • 5,170
  • 15
  • 71
  • 116
2
votes
1 answer

Create subdirectory in Sql Server FileTable

I have a simple script that creates subdirectory in FileTable: INSERT INTO MyFiles (name, is_directory) VALUES ('SomeFolder', 1, 0) It works corrrect and if I run it SqlServer creates subdirectory 'SomeFolder'. But if I try to create nested…
Pupkin
  • 1,211
  • 3
  • 13
  • 30
2
votes
0 answers

Restore database backup with SQL FileTable to same instance

How can I backup and restore a database with FileTable to the same SQL server instance; with FILESTREAM enabled; but with a different name? Whether I do it through the GUI or write out scripts to do so, I get stuck at the same place: The restore to…
Balah
  • 2,530
  • 2
  • 16
  • 24
2
votes
1 answer

Create FileTable directory tree

I'm working on a Custom Document Management System that uses Filestream / FileTable as Document Storage. The Directory structure is as follows: APPNameDir --> Year --> Month --> Files + APPNameDir + 2015 + 12 File 1.pdf …
Alvmad
  • 155
  • 6
2
votes
1 answer

How to use FileTable in EF Code First

I'm using FileTable in SQL Server 2014 and EF code first in my project. When I use this command USE [master] GO ALTER DATABASE [OnlineStore] SET FILESTREAM( DIRECTORY_NAME = N'OnlineStore', NON_TRANSACTED_ACCESS = FULL) WITH NO_WAIT GO it…
Reza Bahari
  • 104
  • 7
2
votes
2 answers

Delete from FILETABLE with foreign key constraint

Background I'm looking into creating a simple web app, a part of which will display Images associated with Items. I've decided to look into using the FILETABLE feature of SQL Server which will allow binary image data to be uploaded into the exposed…
Chris Pickford
  • 8,642
  • 5
  • 42
  • 73
2
votes
0 answers

Architecture Recommendations for custom DMS with Filestream and Filetable

I'm currently in the analysis phase of a Document Management System development that will be the unique entry point of documents from many applications. The size and amount of documents depends on the application. For example, one of them will have…
Alvmad
  • 155
  • 6
2
votes
1 answer

Accessing to SQL Server Filetable from IIS APP POOL

I have an ASP.Net MVC application which is published on the IIS server,in this app I want to access the files which are stored in the filetable of a database,I mean I'm trying to access the files stored in the virtual filetable directory. Note:The…
Shadi
  • 277
  • 4
  • 17
2
votes
1 answer

Preventing duplicate files in a SQL Server 2014 FileTable

I'm planning to write a ASP.NET MVC app that will upload large files (possibly as large as 500 MB) to a SQL Server 2014 FileTable. Is there some way to check if the file already exists in the FileTable before uploading? If the file already exists…
dev5000
  • 99
  • 2
  • 10
2
votes
0 answers

Getting contents of Filetable file_stream in SQL Server 2012

I've been setting up a SQL Server 2012 environment using a Filetable which is full text indexed. Firing queries works well and I'm really happy testing this feature out. After I installed the IFilters for PDF and MS Office documents even searching…
k0alaDEV
  • 61
  • 1
  • 9
2
votes
1 answer

Is SQL Server's filetable suitable for storing big files (bigger than 10 GB)?

There is a project for lab. The requirement to save the lab data (raw data and related infomation ) for research for years. So the data must be saved for years, but the data is so big, every raw data is more than 10 GB. If we store the raw data in…
huoxudong125
  • 1,966
  • 2
  • 26
  • 42
2
votes
1 answer

SQL Server 2012 FileTable mapped to a mounted S3 Virtual Directory

Is it possible to mount an Amazon S3 virtual directory on the machine that handles an Sql Server 2012 database for the purpose of mapping that virtual directory into a filetable in Sql server? What I'm hoping is to take advantage of S3 but use the…
The Prophet
  • 338
  • 5
  • 11
2
votes
1 answer

Create FileTable Or FileStream SQL Type Use Stream in C#

I wan't to create fileTable or filestream type in SQL Server, but I need to create it from Stream not a Location on disk, Is there any way to do this? any suggestion?
Saeid
  • 13,224
  • 32
  • 107
  • 173
2
votes
1 answer

Entity Framework 5.0 and FileTable

So say I have the following tables in my SQL Server 2012 DB: Person PersonId FirstName LastName Photo PhotoId PersonId (fk) DateTaken PhotoFileTable (all the FileTable columns) And the photos stored on disk are structured like…
Nicros
  • 5,031
  • 12
  • 57
  • 101
2
votes
5 answers

File table in Ubuntu OS

Does linux/Ubuntu OS creates a table, which keeps the entry of every file with its absolute address that is stored on the hard drive? Just curious to know, because I am planning to make a file searcher program. I know there are terminal commands…
Naruto
  • 1,710
  • 7
  • 28
  • 39
1 2
3
…
8 9