SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 General SQL Server Forums
 New to SQL Server Administration
 Upgrade to SQL 2012 or 2014
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

ranvir_2k
Posting Yak Master

United Kingdom
173 Posts

Posted - 04/16/2014 :  06:14:21  Show Profile  Reply with Quote
I was wondering what most people are doing in the industry regarding SQL Server upgrades.

I've got a number of SQL Server 2005 and 2008 SQL Servers that I'm planning to upgrade soon.

Is it better to upgrade to 2012 or 2014?

My concern with 2014 is that it has only just been released and may have issues and may not fully be reliable.

Is it better to wait until the product has been released for a while?

tkizer
Almighty SQL Goddess

USA
37296 Posts

Posted - 04/16/2014 :  19:30:02  Show Profile  Visit tkizer's Homepage  Reply with Quote
I would upgrade to 2014 if it were me and if we had the hardware for it. I would say that since SQL Server 2008 or maybe 2005 that it is safe to go with the RTM version, or at least once the first hotfix is released (not service pack).

Tara Kizer
SQL Server MVP since 2007
http://weblogs.sqlteam.com/tarad/
Go to Top of Page

jeffw8713
Aged Yak Warrior

USA
806 Posts

Posted - 04/17/2014 :  13:15:11  Show Profile  Reply with Quote
Before considering either 2012 or 2014 I would validate that the application(s) and/or vendor (if vendor supplied) support that version. I have several systems that cannot be upgraded to 2012 yet because the vendor hasn't certified their application yet.

I have several in-house systems that cannot be upgraded until we have time to create a 'test' environment to evaluate all of the code that would need to be changed (if any).

I would never arbitrarily decide to upgrade any instance of SQL Server to a new version until it has been tested and validated on the new version.
Go to Top of Page

tkizer
Almighty SQL Goddess

USA
37296 Posts

Posted - 04/17/2014 :  13:24:48  Show Profile  Visit tkizer's Homepage  Reply with Quote
Oh yes definitely needs to be tested. I definitely wasn't say to upgrade to 2014 in production without first testing it. What I am saying is that if you are planning on upgrading and can support 2014, then I would go with 2014. We have 5-6 non-prod environments. We would start with dev for the upgrade testing and then work our way through the other environments and then out to prod.

Tara Kizer
SQL Server MVP since 2007
http://weblogs.sqlteam.com/tarad/
Go to Top of Page

ranvir_2k
Posting Yak Master

United Kingdom
173 Posts

Posted - 04/20/2014 :  16:24:06  Show Profile  Reply with Quote
Yes obviously I would test the migration in development, test and then production.

I think 2014 sounds better. Why upgrade to a lower version when a newer version is available?

All of our applications are built in house by our developers so we do all the support ourselves.
Go to Top of Page

jackv
Flowing Fount of Yak Knowledge

United Kingdom
2076 Posts

Posted - 04/22/2014 :  01:42:29  Show Profile  Visit jackv's Homepage  Reply with Quote
It is not unusual for organisations to maintain the latest version - 1 (i.e 2012). There are a number of benefits: vendor certification, product support, product stability, systems management support. Overall, include in your considerations such factors as : standardisation and easy of management

Jack Vamvas
--------------------
http://www.sqlserver-dba.com
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.12 seconds. Powered By: Snitz Forums 2000