Answered by:
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?
Wednesday, January 15, 2014 10:08 PM
Answers
-
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
- Edited by Alberto MorilloMVP Wednesday, January 15, 2014 10:37 PM
- Proposed as answer by Sofiya Li Thursday, January 16, 2014 3:42 AM
- Marked as answer by duncanph Thursday, January 16, 2014 4:10 PM
Wednesday, January 15, 2014 10:33 PM
All replies
-
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
- Edited by Alberto MorilloMVP Wednesday, January 15, 2014 10:37 PM
- Proposed as answer by Sofiya Li Thursday, January 16, 2014 3:42 AM
- Marked as answer by duncanph Thursday, January 16, 2014 4:10 PM
Wednesday, January 15, 2014 10:33 PM -
Thanks! That is the information I needed.Thursday, January 16, 2014 4:10 PM
-
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/
Wednesday, March 26, 2014 6:10 PM