question

JassimAlRahma-9056 avatar image
0 Votes"
JassimAlRahma-9056 asked ErlandSommarskog commented

BFILE alternative in SQL Server

Hi,

What is the datatype available in Microsoft SQL Server to use that is similar to the BFILE in Oracle where you store a pointer of to the file?


Thanks,
Jassim

sql-server-general
· 3
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @JassimAlRahma-9056,

Please check the replies from NaomiNNN and Tom. If the response helped, do "Accept Answer". Your contribution is highly appreciated. If you have further issue, pleas feel free to ask.

0 Votes 0 ·

Is this available in Microsoft SQL Server Express as well?

and does the actual file size count in the total database size or it will only have a reference to it? because if the actual file size will consume from the SQL Express database size then that won't be enough.

0 Votes 0 ·

FILESTREAM is available on SQL Server Express. Good question if they count the size of the FILESTREAM area when they check the 10 GB limit. You will need to test.

But the files are indeed part of the database, so when you backup the database, the files are included. So from that perspective, if you exceed the limit, you have found a loophole.

There is also Filetable. The difference is that with FILESTREAM, the area where the files are located are off-limits, wheras with Filetable, a share is exposed and files can be entered through regular Windows tools. Again, I don't know how that relates to the 10 GB limit.

0 Votes 0 ·
NaomiNNN avatar image
1 Vote"
NaomiNNN answered 66074517 commented
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

TomPhillips-1744 avatar image
1 Vote"
TomPhillips-1744 answered
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.