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
1
vote
0 answers

FileTable and entity framework code first?

I have a MVC project and I want to use SQL FileTable for storing photos and attachments. But it seems to me that Entity Framework code first does not support FileTable. All I could think of was to use script in Up method of migration to alter…
Sami Zohari
  • 11
  • 1
1
vote
1 answer

How to make a FileTable folder name change reflected in Windows Explorer?

I have a FileTable in my SQL Server 2012 database, which contains both folders and files. I wanted to rename a folder, so I executed update MyFileTable set name = 'NewName' where name = 'OldName'; The update was successful, and the file table…
neizan
  • 2,291
  • 2
  • 37
  • 52
1
vote
0 answers

SQL Server 2012 Win32 Share Permissions with EFS and FileTable

I've got SQL Server 2012 working with my Visual Studio SQL Project, as discussed in more detail on my other SO post. FILESTREAMS are enabled, FileTables are created in their own FileGroup, and my SQL Project generates good indexable/searchable…
Todd Sprang
  • 2,899
  • 2
  • 23
  • 40
1
vote
1 answer

What access right to set of Application pool user to access FILESTREAM file share

I'm creating a web app using ASP.NET on Windows Server 2012. I'm using SQL Server 2014 and I have a FileTable the file table maps to the following path \\CIHOST1\MSSQLSERVER\FileStreamDirectory\AvatarsFT\ Both SQL Server and IIS are on the same…
Mihail Shishkov
  • 14,129
  • 7
  • 48
  • 59
1
vote
0 answers

customize right click context menu of linux file or folder using java

I want to run two java application in the sense. When first application executes, it first create a file or folder having only two right click context menu option. Mount Unmount When user click on Unmount file or folder will delete When user…
Ali AKhtar
  • 161
  • 2
  • 12
1
vote
0 answers

WebDAV request for file inside virtual directory

I'm storing files in SQL Server 2012 using a FileTable. Someone logged onto the server can access the files via a virtual directory which SQL Server set up (\\hostname\sqlexpress\FileTableTestFilestreamDirectoryName\FileTableTestFilestream\). I'd…
TheDudeDude
  • 123
  • 1
  • 4
  • 15
1
vote
1 answer

Insert filetable using fileupload from local

I have some basic question about filetable. How do I upload file from local to server(directly to filetable directory)? I have tried, but error 'access denied to xxx path' was popped up When I try to insert filetable using sql command (BULK insert…
Soni gunz
  • 13
  • 4
1
vote
1 answer

How to pass a string with spaces to 'CONTAINS' IN T-SQL

How to pass a string This is a sample to CONTAINS in "File Table" in SQL Server 2012. CONTAINS keyword does not accept spaces, brackets. SELECT * FROM Sample_FILETable WHERE CONTAINS (file_stream, 'This is a sample') ;
user3315245
  • 83
  • 7
1
vote
1 answer

Exporting files from Oracle BLOB to SQL FileTable - file types?

I am trying to do an ETL for a data conversion/upgrade of an Oracle table that contains HUGEBLOB files, and the columns in that table list only a file name and the MIME type. The file names don't always (in a lot of cases in fact) provide the…
kharvey
  • 71
  • 1
  • 9
1
vote
0 answers

Store Large files in SQL FileTables using Entity Framework

How I can store large files (in 1GB or more) in SQL Server FileTables using Entity Framework in asp MVC. I'm getting file from client side in HttpPostFileBase object. Guide me what is best way for achieve this requirement.
mshoaiblibra
  • 390
  • 4
  • 15
1
vote
0 answers

SQL Server FileTable weird behavior in cluster environment

We have enabled the Filetable feature in our SQL Server Cluster environment. Whenever one node fails, SQL Server automatically fails over to a different node but the Filetable is not getting enabled automatically, users have to go to cluster…
user145610
  • 2,949
  • 4
  • 43
  • 75
1
vote
1 answer

How to insert a file under a directory in SQL Filetable

I created a directory in File Table. Now I need to insert files inside that directory. As parent_path_locator can not be set, I can't think of how to achieve this. I am doing all these in code. This is how i created directory; Dim insertDir =…
voddy
  • 950
  • 1
  • 11
  • 21
1
vote
0 answers

Exporting SQL Server Data Files and Remounting as FileTables

We would like to move data from our local SQL Server 2008 R2 instance into a SQL Server 2012 running on Amazon EC2 (virtual machine in the AWS cloud). My first thought was to: (a) export the data using a SQL Server command or SSIS (b) GZIP and TAR…
rocketfish
  • 19
  • 1
  • 3
1
vote
1 answer

Does the stream_id change if I move the file to some other directory within the same filetable?

I am using MSSQL 2012 and its feature called File Table to store some big amount of files stored in hierarchical directories. I am referencing the entries on the file from other custom tables via the column stream_id, which is unique for every…
Tomas Walek
  • 2,516
  • 2
  • 23
  • 37
1
vote
0 answers

cross-server access to SQL Server FileTable share

Can you point me to any information about cross-server access to the SQL Server FileTable share? We wanted to use this to manage variable-content for our Web Applications (which are running in a load-balanced configuration). The share works great…
Michael Sawicky
  • 11
  • 1
1 2 3
…
8 9