SQL 2005 to SQL 2014

Question

The following MSDN reference http://msdn.microsoft.com/en-us/library/ms143393%28v=sql.120%29.aspx says

SQL Server 2014 supports upgrade from the following versions of SQL Server:

• SQL Server 2008 SP3 or later
• SQL Server 2008 R2 SP2 or later
• SQL Server 2012 SP1 or later

However, in our testing, it is possible to upgrade from SQL 2005 SP4 to SQL 2014.  There are no messages or detection errors when doing so.  Will the final release of SQL 2014 support upgrading from SQL 2005 directly or will there be detection added to the installation to prevent it?

Answer 1

Hello,

SQL Server 2005 won’t be supported as a valid upgrade path when SQL Server 2014 RTM is released as the article you posted states. The behavior you are seeing with the CTP version of SQL Server 2014 maybe is part due to some binaries of the SQL Server 2012 version still in use on the CTP version.

Hope this helps.

Regards,

Alberto Morillo
SQLCoffee.com

Answer 2

Thanks! That is the information I needed.

Answer 3

In the RTM of SQL Server 2014, SQL 2005 upgrade is supported.

See Supported Version and Edition Upgrades

David

---

David http://blogs.msdn.com/b/dbrowne/