How to upgrade SQL 2005 Express to SQL 2014 Express

Introduction

This topic explains the step needed to upgrade from one version of SQL to another.

  1. Start the SQL installation and when prompted select the Upgrade from SQL Server 2005 option.

  1. Select the I accept the licence terms option and click Next.

 

The upgrade will now scan your computer and install setup files:

  1. Select the instance of SQL you wish to upgrade (in this example we are choosing SQLEXPRESS05):


Another check will be performed:

 

Allow the install to progress:

 

Installation process will start:

 

Installation completed: