Please start any new threads on our new site at http://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

Our new SQL Server Forums are live! Come on over! We've restricted the ability to create new threads on these forums.

SQL Server Forums
Profile | Active Topics | Members | Search | Forum FAQ
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 General SQL Server Forums
 New to SQL Server Administration
 Should I consider SQL 2014?
 Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

jbruyet1
Starting Member

USA
35 Posts

Posted - 05/07/2015 :  11:44:36  Show Profile  Reply with Quote
Hey all, I'm not a SQL person but it's now my responsibility to take care of our exiting SQL servers. I'm currently running a large program (of 17 individual databases) on SQL 2005. I contacted the vendor and asked about upgrading to SQL 2014 and was told that they don't have anyone using 2014 yet. Does 2014 have any features that would make it worthwhile to go with it or should I consider SQL 2012?

Thanks,

Joe B

jbruyet1
Starting Member

USA
35 Posts

Posted - 05/07/2015 :  11:45:52  Show Profile  Reply with Quote
Also, the only search button I could find sends me to external web sites. How so I search for topics in this forum?
Go to Top of Page

Kristen
Test

United Kingdom
22859 Posts

Posted - 05/07/2015 :  15:06:58  Show Profile  Reply with Quote
If you upgrade to SQL 2014 your license will allow use of SQL 2012 - so you could pay for 2014, upgrade to 2012 (now) and get a free upgrade to 2014 later (when vendor supports it).

You can set Database Compatibility to, say, SQL 2008 - so your application SHOULD!!! run fine in the mode. Needs testing though, unless vendor supports it already. I don't think Compatibility with SQL 2005 is available in 2014, but it is in 2012 (you'd need to check that, but maybe Vendor supports something more recent than 2005 )

Search is here:

http://www.sqlteam.com/forums/search.asp

Edited by - Kristen on 05/08/2015 18:35:01
Go to Top of Page

jackv
Flowing Fount of Yak Knowledge

United Kingdom
2179 Posts

Posted - 05/08/2015 :  01:41:43  Show Profile  Visit jackv's Homepage  Reply with Quote
Definately check and confirm the vendor certifies the target SQL Server version.Also check here for more notes on compatibility level issues http://www.sqlserver-dba.com/2014/01/compatibility-level.html

A key point is to review code when restoring onto a newer version

Jack Vamvas
--------------------
http://www.sqlserver-dba.com
Go to Top of Page

Kristen
Test

United Kingdom
22859 Posts

Posted - 05/08/2015 :  04:11:49  Show Profile  Reply with Quote
My thoughts on upgrading to latest version of SQL are here:
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=201076
Go to Top of Page

jbruyet1
Starting Member

USA
35 Posts

Posted - 05/08/2015 :  12:30:31  Show Profile  Reply with Quote
Thanks all. I'll follow those links and see what I can find out. FWIW I heard back from my vendor on 2014 -- nope. I asked about 2012 and now I'm waiting to hear about that.

Thanks,

Joe B
Go to Top of Page

jbruyet1
Starting Member

USA
35 Posts

Posted - 05/08/2015 :  16:33:39  Show Profile  Reply with Quote
Ok, 2012 is good so I'll go with 2012.

Thanks,

Joe B
Go to Top of Page
  Previous Topic Topic Next 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.04 seconds. Powered By: Snitz Forums 2000