Sql-server – upgrade SQL Server 2008 R2 Standard to SQL Server 2014 Developer

installationmigrationsql serversql server 2014sql-server-2008-r2

Is there a migration path to upgrade SQL Server 2008 R2 Standard to SQL Server 2014 Developer?

If so, are there any pain points?

If not, how would you recommend I proceed?

The context of this question is a Developer machine that is running SQL Server 2008 R2 Standard and wants to now run SQL Server 2014 Developer.

Update 07/11/2014 – The accepted answer worked for me. I installed SQL Server 2014 Developer as a named instance then followed Zasz's StackOverflow answer to convert the named instance to the default instance.

Best Answer

That is not a supported upgrade path.

how would you recommend I proceed?

My recommendation would be to install side-by-side and then migrate (backup and restore) your databases to the SQL Server 2014 instance.