Broadcast Radio Forums

MSQL 2008R2 to MSQL 2012


http://forums.broadcastradio.com/Topic8660.aspx

By lindenwade - Saturday, September 17, 2016 9:33:40 AM

Hello! 

I was just wondering whether it was worth upgrading to Microsoft SQL 2012 from 2008R2, and whether it was straightforward enough to do? 

By showbizshane - Wednesday, September 21, 2016 1:13:28 PM

lindenwade - Saturday, September 17, 2016 9:33:40 AM
Hello! 

I was just wondering whether it was worth upgrading to Microsoft SQL 2012 from 2008R2, and whether it was straightforward enough to do? 


SQL2008R2 is end of life and out of support for sp4 on 09/07/2019.  Ideally before that date I'd suggest you do upgrade. 

I've found SQL2012STD to be responsive and has improved look up speeds and retrieving data.   Ideally SQL2008R2 should be run on Server 2008R2 and vice versa for SQL2012 should be run on Server 2012.  The express editions are just as good but are limited to memory and database size.