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
28
votes
2 answers

Unix system file tables

I am confused about Unix system file tables. When two or more processes open a file for reading, does the system file table create separate entries for each process or a single entry? If a single entry is created for multiple processes opening the…
Alfred
  • 1,543
  • 7
  • 33
  • 45
13
votes
3 answers

FileStream vs FileTable

I want to store images in a sql database. The size of the image is between 50kb to 1mb. I was reading about a FileStream and a FileTable but I don't know which to choose. Each row will have 2 images and some other fields. The images will never be…
Eelco
  • 339
  • 1
  • 3
  • 13
12
votes
5 answers

FileTable Delimited String Split

EDIT - To be clear I will put the goal sentence at the top. The test and my question is whether there is a way to get the same performance as a temp table without using a temp table. I feel this should be an easy question but I am stuck. I am…
Joe C
  • 3,925
  • 2
  • 11
  • 31
11
votes
3 answers

Can Microsoft Azure SQL Server utilize FileTable / Blob Storage?

Background/Problem I'm trying to do something along the lines of the following but can't find it documented: SQL Azure Database (not VM) Hook it up to some (blob) storage Utilize FileTables to store files to the db/filesystem Clarification: Rough…
SeanKilleen
  • 8,809
  • 17
  • 80
  • 133
9
votes
1 answer

SQL Server's FileTable and ASP.NET: permissions for user

I'm building an app which needs to save files to filetable through the file share. I've already managed to get it working, but I'm curious about the solution required. In my case, I'm using a partially contained database (which has local users) and…
Luis Abreu
  • 4,008
  • 9
  • 34
  • 63
9
votes
4 answers

Creating Sub Directory via SQL INSERT using FileTable

Previously, I requested how to create a directory within a FileTable without using File I/O APIs. I now want to create a subdirectory to the parent directory I just created. How do assign my parent during insert? It appears that parent_path_locator…
SliverNinja - MSFT
  • 31,051
  • 11
  • 110
  • 173
8
votes
4 answers

How to enable permissions in SQL Server 2012 FileTable folder share?

After successfully creating a FileTable, I tried viewing the fileshare but my permissions are denied. In Management Studio, right-clicking on FileTable then "Explore FilteTable Directory" gives me the following error message: The File location…
Laith
  • 6,071
  • 1
  • 33
  • 60
7
votes
1 answer

Sql Server FileTable drawbacks

I'm looking at using File Tables instead of simply storing the file as binary data in the database, or storing a column in the database that contains a URL to a file share. Our apps use Entity Framework, so that's one minor snag that I see, but one…
Matt M
  • 3,699
  • 5
  • 48
  • 76
7
votes
1 answer

Explorer not updating after creating directories with SQL Server 2012 FileTable

I am trying to create directories in a SQL Server FileTable via a stored procedure where I call the following code: INSERT INTO tblMyFiles (name, is_directory, is_archive) VALUES ('foldername', 1, 0); After calling this code I can see the row…
Olly
  • 587
  • 1
  • 5
  • 14
6
votes
1 answer

ASP.Net Core 2.0 FileTable Usage

I have an existing ASP.Net Core 2.0 project that uses Entity Framework Core and an SQL Server 2012 database. There is a requirement to add a form that allows users to upload documents when creating a new item, my initial thoughts were to make use of…
mheptinstall
  • 2,109
  • 3
  • 24
  • 44
5
votes
3 answers

Access Denied when inserting file into Sql Server 2012 FileTable using File.CreateFile in ASP.NET website

I have an ASP.NET website. I want to upload a file to the website and save it into a FileTable in SqlServer 2012. Once uploaded, my website code has a Stream object which I would like to save using System.IO.File.Create() The FileTable is…
Paul Bullivant
  • 668
  • 7
  • 13
5
votes
1 answer

Filestream shared folder permission issues

I'm trying to drag and drop a file from my desktop to my local MSSQLSERVER shared folder/directory used for filestream files. Everytime I do so, I receive the following Windows error - "You need permission to perform this action." I feel like I've…
user2583472
  • 51
  • 1
  • 3
5
votes
1 answer

SQL Server 2012 FileTable- is a file stored IN the database?

If I create a FileTable in SQL server 2012, and then was to drop a 4G file onto the NT filesystem (that was in the filestream), would that entire 4G file be read into the table's filestream column? Is SQL in fact making a COPY of my 4G file? Or…
Nicros
  • 5,031
  • 12
  • 57
  • 101
5
votes
1 answer

FILESTREAM/FILETABLE Clarifications for Implementation

Recently our team was looking at FILESTREAM to expand the capabilities of our proprietary application. The main purpose of this app is managing the various PDFS, Images and documents to all of the parts we manufacture. Our ASP application uses a few…
jjhayter
  • 352
  • 4
  • 19
4
votes
0 answers

How can I map Sql File Table in Entity Framework Core

Recently the company I work for used SQL Server FileTables. How can I map these tables in Entity Framework Core? This is one of them: I've searched. There are some solutions like creating a stored procedure and so on. But unfortunately I cannot…
Mohammad Mirmostafa
  • 1,720
  • 2
  • 16
  • 32
1
2 3
…
8 9