Stack Overflow
Stack Overflow

Questions tagged [sqlfilestream]

SqlFileStream is a class that exposes SQL Server data that is stored with the FILESTREAM column attribute as a sequence of bytes.

The SqlFileStream class is used to work with varbinary(max) data stored with the FILESTREAM attribute in a SQL Server 2008 database. You must install the .NET Framework 3.5 SP1 (or later) to use System.Data.SqlTypes.SqlFileStream to work with FILESTREAM data.

Specifying the FILESTREAM attribute on a varbinary(max) column causes SQL Server to store the data in the local NTFS file system instead of in the database file. Transact-SQL statements provide data manipulation capabilities within the server, and Win32 file system interfaces provide streaming access to the data.

MSDN doc

102 questions
0
votes
1 answer

SQL FullText search for PDF files

First of all, thank you for comming here : I wrote a script in SQL able to find words in a file, with a lot of help of some websites (http://dzapart.blogspot.fr/2012/04/full-text-search-with-pdf-in-microsoft.html) The problem is here : I have…
Pingu
  • 53
  • 10
0
votes
1 answer

MVC Large File Uploads Running Out of Memory

.Net 4.5.1 - MVC5 - EF6 The requirement is to allow large file uploads(<200MB). I have a ViewModel with HttpPostedFileBase. I set the Input Stream of that to a DB Entity NonMapped Stream Property. Which is then sent to the Repository where I save…
Tony
  • 1,297
  • 10
  • 17
0
votes
2 answers

Performance loss JSON in Sql Server database

Currently I am storing JSON in my database as VARCHAR(max) that contains some transformations. One of our techs is asking to store the original JSON it was transformed from. I'm afraid that if I add another JSON column it is going to bloat the page…
micahhoover
  • 2,101
  • 8
  • 33
  • 53
0
votes
1 answer

SQL FILESTREAM breaking

Scenario: I recently added a component to my ASP.NET MVC app that allows them to upload files into the database. Since these files average more than 2MB, I elected to use FILESTREAMs. I save the HttpPostedFileBase to a temp file, do some business…
Ethan Reesor
  • 2,090
  • 1
  • 23
  • 40
0
votes
1 answer

Filestream on PowerBuilder

I am storing some (blob) images on a SQL 2012 express using filestream. I want to know how to show and retrieve those images on my client app from the database using PowerBuilder 12.5 Any idea? Thanks in advance.
wen
  • 13
  • 6
0
votes
0 answers

Best way to move data from SQL to file system (FileStream?)

At the moment I have a SQL Server Express instance with a database nearing the 10gig limit. I have a table that stores details about activities, one column being "Note" which can be up to 3000 characters long. I would like to take this table and…
Greg
  • 77
  • 1
  • 8
0
votes
1 answer

SQLFileStream with a chunked file

I'm a little stuck in trying to upload files into our SQL DB using FileStream. I've followed this example http://www.codeproject.com/Articles/128657/How-Do-I-Use-SQL-File-Stream but the difference is we upload the file in 10mb chunks. On the first…
MikeS
  • 647
  • 5
  • 18
0
votes
1 answer

Handling file size for SQL FILESTREAM data

What is the proper way to handle file sizes when using Sql Server's FILESTREAM feature to store documents in the database? I know that you can use the TSQL command DATALENGTH() on the filestream column, but regarding to this Microsoft article this…
magnattic
  • 12,638
  • 13
  • 62
  • 115
-1
votes
1 answer

How to migrate the schema of a SQL Server database from on-premise to SQL Server on AWS RDS with non-supported features

I'm working on taking a on-premise server that works with SQL Server 2019 and migrating this to the cloud. The data right now is not the important thing, but rather the schema since this is a proof of concept. The main issue is that the on-premise…
Lacrosse343
  • 491
  • 1
  • 3
  • 18
-1
votes
1 answer

Stored exe File in sql is not executable after Loaded From SQL Server

We are trying to store an executable(exe) file in SQL. We are getting no error either writing or reading. Just the file we stored is not working after downloading back. This is how we store the file: databaseFilePut(@"FilePath", con,…
Muhammed Lutfu ODABASOGLU
  • 75
  • 7
-1
votes
1 answer

SQL Server 2008 filestream read into web page

I have a SQL Server table with filestream enabled. I am able to upload files here and update as well. How do I read these files into an .aspx web page? The files are .pdf files. There are 2 files are associated with each row. I am reading the row…
user3285061
  • 23
  • 8
-1
votes
1 answer

SQL Server BLOBs vs file links

Im planning to organise picture's storage in SQL Server from public folder. I want to do it as BLOBs. I read in the internet that if any file from source folder is accidentally removed, it can lead to database failure. Is it correct? Did someone…
Ele
  • 1
  • 1
1 2 3 4 5 6
7