FILESTREAM in SSDS?

Question

Hi,

Are there are plans to support the Filestream type of SQL Server 2008 in SSDS?

Thanks,
David Cuccia

Answer 1

Kinda...

BLOB support is coming, which will feel a lot like the FileStream data type, but it will be exposed through our A.C.E. Model. (Authority, Container, Entity)

HTH,
Dave

Answer 2

I doubt if SSDS would provide outside access to a file system.

---

--rj (http://oakleafblog.blogspot.com)

Answer 3

BLOBs will be supported in SSDS but it will be over the REST and SOAP interfaces.  You will be able to stream it in/out of the service and we will deal with all storage aspects of it. 

Do you have any specific requirements for your application?  If you do please post a note or send me an email.

Thanks

---

Tonyp

Answer 4

Normally when we access file system through HTTP or FTP, we show the file upload / download progress, I wonder how can I report the progress through SOAP + SSDS.

Answer 5

Thanks Tony! Will you support batching of multiple blob inserts into a single ChangeSet, as in Astoria? Will there be a blob size limit? Also, what if any support will you have for resuming "paused" upload streams upon reconnection?

Answer 6

 
Regarding batch inserts of blob:  In the first iteration of the blob implementation we will not support batching of multiple independent blobs in a single request.  You may want to post a note in the feedback thread around the specific requirements for multiple blob batching.   

Regarding the size limit:  On the initial few weeks of the release (during beta) we may limit the size of a single blob but there are no plans for limiting blob sizes in production.  You may hit the ultimate size limit of your container but the blob itself will not be limited.  What size blobs do you need?

With respect to resume:  I think it would be best to delay this subject for a few weeks until the blob support is in -- I'll make sure the docs and examples address the issue when the blob support comes in.

---

Tonyp