Streaming media and SQL Server 2005

  • Thread starter Thread starter Manuel Alves
  • Start date Start date
M

Manuel Alves

Hi,
Is it possible to store media files (like windows .wmv) on SQL Server 2005
and stream it back to the client via media server (not just download it)?

Regards,
Manuel Alves
 
Hello Manuel,

As I know, there are some way to save a binary file in SQL server:

http://support.microsoft.com/kb/317043
How to read and write a file to and from a BLOB column by using chunking in
ADO.NET and Visual C# .NET

But I am not sure if there is way to connect media server to SQL database.
I suggest you may post this question in a media server newsgroup, for
example:

microsoft.public.windowsmedia.server

Regards,

Luke Zhang
Microsoft Online Community Support

==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================

(This posting is provided "AS IS", with no warranties, and confers no
rights.)
 
Hi,
Thank you. I'll try the correct newsgroup. By the way, I already use SQL
Server to store and retrieve small binary files (under 100Kb) using VB.NET
(winforms and ASP 2.0), and I was just wondering about streaming (much
larger files and streaming <> just retrieve).

Best regards,
Manuel Alves
 
As I know, SQL server can save a binary file less than 2 GB. But larger
file may cause slow performance when there are multiple requests.

Regards,

Luke Zhang
Microsoft Online Community Support

==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================

(This posting is provided "AS IS", with no warranties, and confers no
rights.)
 
Thanks,
Besides the fact that sql server won't be as good as the file system for
storing big files like this it lacks the capabilities of the media server.
I've got an answer from microsoft.public.windowsmedia.server. Thank you all
for your time.
--- from microsoft.public.windowsmedia.server:
Hi,
Is it possible to store media files (like windows .wmv) on SQL Server 2005
and stream it back to the client via media server (not just download it)?
Click to expand...

Yes, you can do that I suppose. It's a lot of work though for no gain.
I already use SQL Server to store and retrieve small binary files (under
100Kb) using VB.NET (winforms and ASP 2.0), and I was just wondering about
streaming (much larger files and streaming <> just retrieve).
Click to expand...

In your scenario, you're using SQL server to store vast amounts of
data and hitting it really hard. Then you're getting WMS to transfer
the same data over the network. Probably you'd have to assemble some
sort of stream writer to mimic a WMS proxy

I can't see why you'd want to do all that work when you can simply use
SQL server to create the playlist dynamically (using the XML writer)
from a stored list of file locations on the server ?

Cheers - Neil
 
He would probably want to use SQL Server 2005 to organize but not store
the media.

That is, have a table with

TITLE
YEAR
FILENAME

That points to the media which can be displayed on a web page.

When the user clicks on the hyperlink, it streams the media through
media server.
 
Back
Top