Streaming media and SQL Server 2005

[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

[Luke Zhang [MSFT]]

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.)

[Manuel Alves]

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

"Luke Zhang [MSFT]" <lu******@online.microsoft.com> wrote in message
news:OC**************@TK2MSFTNGXA01.phx.gbl...

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.)

[Luke Zhang [MSFT]]

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.)

[Manuel Alves]

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)?
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).
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

"Luke Zhang [MSFT]" <lu******@online.microsoft.com> wrote in message
news:RQ*************@TK2MSFTNGXA01.phx.gbl... 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.)

[John A. Bailo]

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.

Manuel Alves wrote:

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)?

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).

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

"Luke Zhang [MSFT]" <lu******@online.microsoft.com> wrote in message
news:RQ*************@TK2MSFTNGXA01.phx.gbl...

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.)