How to upgrade from SQL Server 2008

by Teodor Nechita
Teodor Nechita
Teodor Nechita
Software Managing Editor
Eager to help those in need, Teodor writes articles daily on subjects regarding Windows, Xbox, and all things tech-related. When not working, you may usually find him either... read more
Affiliate Disclosure
sql server
To fix various PC problems, we recommend DriverFix:
This software will keep your drivers up and running, thus keeping you safe from common computer errors and hardware failure. Check all your drivers now in 3 easy steps:

  1. Download DriverFix (verified download file).
  2. Click Start Scan to find all problematic drivers.
  3. Click Update Drivers to get new versions and avoid system malfunctionings.
  • DriverFix has been downloaded by 0 readers this month.

Microsoft’s SQL Server is a relational database management system. Its main function is to retrieve data as requested by other software applications.

These applications may run either on the same computer or on another computer across a network, including over the Internet.

As you may already know, Microsoft ceased support for SQL Server 2008 and 2008 R2 back in 2019. That being said, users are now forced to upgrade if they want to continue using the product securely.

That is why we’ve compiled this step-by-step guide that will show you exactly how you can upgrade from SQL Server 2008 yo 2012, 2016, etc.

Before proceeding with these steps, there are several things that you need to know about the upgrade process:

  • When you upgrade SQL Server, the previous version of SQL Server will be overwritten
  • It is a good idea to back up any SQL Server data you have before the upgrade
  • You cannot upgrade SQL Server Express or SQL Server Developer, as these are not supported

Looking for a hosting service for SQL Server? check out our top picks!

How do I upgrade from SQL Server 2008?

  1. Insert the SQL Server installation media
  2. Go to the root folder, and double-click Setup.exe.
    • The Installation Wizard will now start the SQL Server Installation CenterSQL Server Installation Center
  3. To upgrade an existing instance of SQL Server, select Installation
  4. Click an option to indicate whether you are upgrading to a free edition of SQL Server, or whether you have a PID key
  5. On the License Terms page, select I accept the license terms
    • The Microsoft Update page will appear
  6.  Check within the Microsoft Update page to include the latest updates when you scan for Windows Update
  7. Check or uncheck the Include SQL Server product updates checkbox
    • This depends on whether you want the latest updates or not
    • The setup should now start downloading, extracting and installing the setup files
  8. On the Select Instance page, specify the instance of SQL Server to upgrade
  9. On the Instance Configuration page, specify the Instance ID for the instance of SQL Server
  10. Click Install
  11. Restart your PC

By following these steps, you should be able to efficiently upgrade from SQL Server 2008.

Additionally, if you remembered to back up all of your data before proceeding with the process, then you should be able to migrate it to the new OS without any issues.

Keep in mind that the same process applies when upgrading to later versions of the product as well, such as 2014, 2016, etc.

Did you find this article useful? Let us know in the comment section below.


idee restoro Still having issues? Fix them with this tool:
  1. Download this PC Repair Tool rated Great on (download starts on this page).
  2. Click Start Scan to find Windows issues that could be causing PC problems.
  3. Click Repair All to fix issues with Patented Technologies (Exclusive Discount for our readers).

Restoro has been downloaded by 0 readers this month.

This article covers:Topics: