Compatibility levels in SQL 2014

• nelsonj-902869

  SSCarpal Tunnel

  Points: 4716

  More actions

  June 10, 2016 at 4:09 pm

  #319377

  We will be doing our "first" SQL 2014 install on a server that will be handling up to 8 different databases. These are not large dbs (<15 GB) and the biggest problem I am mulling over is the fact that some of the vendors/manufacturers involved are insisting that "their" product is not compatible with SQL 2014. One currently is on a SQL 2005 server, so I'm curious if 2014 has a setting of 90 for compatibility?

  Also, at least two other databases are at either SQL 2008 or SQL 2012 and I'm not certain if I can have four or more databases running under SQL 2014 with these different compatibility settings. Once I get the software CD I can run the Upgrade Advisor to see if any of these older databases "can" be upgraded, but in a pinch, I am hoping that I can run several different compatibility levels on one SQL 2014 server.

  Thanks for the feedback. J.Nelson

• Jacob Wilkins

  One Orange Chip

  Points: 27976

  More actions

  June 10, 2016 at 4:12 pm

  #1884489

  Compatibility level 90 is not supported in SQL Server 2014. Compatibility levels 100 and up are, however.

  https://msdn.microsoft.com/en-us/library/bb510680.aspx

  Cheers!

• nelsonj-902869

  SSCarpal Tunnel

  Points: 4716

  More actions

  June 10, 2016 at 4:23 pm

  #1884490

  Ok - thanks for the quick reply. JN