Reply to thread

Message

<blockquote data-quote="sjevtic" data-source="post: 857367" data-attributes="member: 118214">SQL Server Express, though free, is pretty powerful, and has become increasingly so over the last few years, to the point of being sufficient for a lot of small business applications that don't need five nines of reliability. Though any edition of SQL Server should work for TV-Server, even the Express edition is more than powerful enough. I have not tried SQL Server Express 2012, but am using SQL Server Express 2008 R2 SP1, as I haven't been able to find much here in either the wiki or forum referring to the 2012 version, whereas both the 2005 and 2008 versions are suggested in the wiki.&nbsp;The most basic distribution of SQL Server Express will work fine, though the &quot;with tools&quot; version is nice since it comes bundled with SQL Server Management Studio, which is a rather useful administration tool.&nbsp;You don't need SQL Server Express to do what you want to do, and in fact, if you already have a largely configured and working TV-Server setup, you'll have to go through some amount of effort to switch that will probably unjustified unless you have other sound motives to do so. I'm not trying to promote SQL Server at all in fact, it is just what I have set up in my installation, so I used it in my example. What I was trying to say though is that MySQL has a similar utility to SQL Servers's sqlcmd, called mysql, that would allow you to create a query that quickly updates your videoSource and audioSource values for a lot of channels all at once. The arguments to mysql differ a bit from those used by sqlcmd (e.g., mysql uses a &quot;-e&quot; option to do the same thing as sqlcmd's &quot;-Q&quot; option), but the spirit of it is very similar.&nbsp;Sasha</blockquote>

[QUOTE="sjevtic, post: 857367, member: 118214"] SQL Server Express, though free, is pretty powerful, and has become increasingly so over the last few years, to the point of being sufficient for a lot of small business applications that don't need five nines of reliability. Though any edition of SQL Server should work for TV-Server, even the Express edition is more than powerful enough. I have not tried SQL Server Express 2012, but am using SQL Server Express 2008 R2 SP1, as I haven't been able to find much here in either the wiki or forum referring to the 2012 version, whereas both the 2005 and 2008 versions are suggested in the wiki. The most basic distribution of SQL Server Express will work fine, though the "with tools" version is nice since it comes bundled with SQL Server Management Studio, which is a rather useful administration tool. You don't need SQL Server Express to do what you want to do, and in fact, if you already have a largely configured and working TV-Server setup, you'll have to go through some amount of effort to switch that will probably unjustified unless you have other sound motives to do so. I'm not trying to promote SQL Server at all in fact, it is just what I have set up in my installation, so I used it in my example. What I was trying to say though is that MySQL has a similar utility to SQL Servers's sqlcmd, called mysql, that would allow you to create a query that quickly updates your videoSource and audioSource values for a lot of channels all at once. The arguments to mysql differ a bit from those used by sqlcmd (e.g., mysql uses a "-e" option to do the same thing as sqlcmd's "-Q" option), but the spirit of it is very similar. Sasha [/QUOTE]

Verification