You’ll notice that SQL Server 2005 (90) is a database Compatibility Level option on SQL Server 2014 (RTM & CU1 at the time of this blog).
You’ll get an error message if you attempt to use it.
A side effect of this option is that a restore or attach of a SQL Server 2005 database onto SQL Server 2014 is possible; however, the database compatibility level will automatically be set to use SQL Server 2008 (100). This saves you the step of having to transfer the database to a SQL Server 2008, or higher, instance before transitioning to SQL Server 2014.
You cannot directly attach a SQL Server 2000 database to SQL Server 2014 and as per SQL Server 2012 you’ll see the following error in the SQL Server errorlog.
click on image to enlarge
Previous
Next