Hello,

We work with a SQL developer but he suggested we search to see if there was a product we could customize that already did what we wanted.   We are starting a new company that will have videos for athletes of all their training sessions.   We'd like to be able to search through the videos by player name, date, potential key words as well as gather by team and a few other things.   Eventually we'd also like to automate converting them to a lower res format for streaming.

I tried searching but all I can find is videos on SQL - e.g. training.

Is SQL an option for video or should I be looking at some other database?    Anyone know of a SQL based commercial product that might be close to what we are looking for?

• Edited by boe_d 17 hours 0 minutes ago

Hi boe_d,

Based on your description, do you want to store videos in SQL Server database? If that is the case, you can create a table that will store the file data, file name, file size, player name, date as follows, then upload video files in the table. For more details, please review this similar blog.

Create table Videos

 (

 ID Int identity,

 Video varbinary(MAX),

 Video_Name nvarchar(50),

 Video_Size bigint,
 Player_name nvarchar(50),
 date datetime

 )

Also you can use the FILESTREAM feature in SQL Server 2008 or later version to store videos. FILESTREAM integrates the SQL Server Database Engine with an NTFS file system by storing varbinary(max) binary large object (BLOB) data as files on the file system. Transact-SQL statements can insert, update, query, search, and back up FILESTREAM data.

For more details about FILESTREAM, please review this blog: Using FILESTREAM to Store BLOBs in the NTFS File System in SQL Server 2008.


Thanks,
Lydia

In addtion

You can store in the table only the link to the video file and a video itself store on the file system...