June 10, 2016 at 4:09 pm
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
June 10, 2016 at 4:12 pm
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!
June 10, 2016 at 4:23 pm
Ok - thanks for the quick reply. JN
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply