Is Streaming Video possible with Sql Filestream?

We have stored all media in Sql Filestream, but now we'll need Video and Audio streaming... Will this be possible with Sql Filestream or will I have to take all of the Video and Audio out of the database?

Which technology would you use to enable Video/Audio Streaming?

• WebORB
• FluorineFX
• Wowza (way better I think t开发者_运维百科han the first two)
• IIS Media (haven't looked into this yet)

---

When using IIS Media its not possible to store the data in a SQL Fielstream.

For further details check here.

It's possibly very similar with the rest of your suggested solutions, since all of them need to re encode the material to enable streaming (if its not in the necessary format already).

You actually have 2 problems:

1. Re encoding the videos into a format that enables you to stream it via the server platform you choose, just for this part you need to extract the files from the db since the encoding tools can't be fed from a database, even if its a SQL FileStream
2. Store the encoded files somewhere the media servers can access them, again they don't allow a SQL Server as a data soure, they probably have their own storing infrastructure or use the file system.

Conclusion:
The FileStream is extremely helpful when you have full control over server/client, but sadly not in your case. You will probably have to extract all files from the DB.

---

The FileTable feature in SQL Server "Denali" (not yet released) is designed specifically for this scenario (amongst others).

There's a good overview link here: Using FileTables to Manage Unstructured FILESTREAM Data.

This will allow you to directly access and play these files through a provided UNC path without requiring any changes to the application, so you can use any of the above mentioned streaming servers.