Store Recording in Database

Question

0.00/5 (No votes)

See more:

SQL-Server-2005

.NET3.5

, +

Hi experts,
I want to store recording (voice recording) in my sql2005 database. Please let me is it possible if yes then how?

Thanks.

Posted 11-Aug-11 10:38am

R. M. Sohail Arshed

Updated 11-Aug-11 10:56am

v2

Add a Solution

Comments

Wendelius 11-Aug-11 16:45pm

What do you mean with recording.

R. M. Sohail Arshed 11-Aug-11 16:56pm

voice recording

Wendelius 11-Aug-11 17:09pm

Answer updated.

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Wendelius · Accepted Answer · 2011-08-11T10:49:00

Solution 1

If you mean that you want to keep track on changes that happen inside the database, the easiest way is to create triggers on tables.

In these triggers you can record relevant information about the change for example to another table. See: CREATE TRIGGER (Transact-SQL)[^]

Okay, so you want to store binary data into the database. Perhaps this would help: How to store and fetch binary data into a file stream column[^]?

Posted 11-Aug-11 10:49am

Wendelius

Updated 11-Aug-11 11:03am

v2

Comments

R. M. Sohail Arshed 11-Aug-11 17:14pm

Hey Mika, I liked your profile man, you are kind of guru :)
anyways what you suggest shall i go for it, like storing recorded stream into database or use some other technique as well?

Wendelius 11-Aug-11 17:21pm

Well, that depends on the business requirements :) When storing the data to the database you would have one, centralized place for the data. The beauty in filestream is that you can access the data also via other methods than SQL. I guess that if you need the data (recordings) to be safe and to modify them transactionally, database would be good. However, if you just need to get them to some place accessible to other users you could also use for example a network share.

R. M. Sohail Arshed 11-Aug-11 17:38pm

yes indeed, that one is a good suggestion :)

R. M. Sohail Arshed 11-Aug-11 17:38pm

if we talked about in a big scenario, like we need to store 1min voice recording after every 2mins from 20 different client machines, don't you think it will cost more space with database?

Wendelius 12-Aug-11 11:58am

Yes, a little bit since the database has 'pointers' to the actual files etc but then again you have good backup mechanisms, transactionality etc. So basically you need to gather pros and cons for each possible solution and make the decision based on those :)