How to upgrade from SQL Server 2008

How to upgrade from SQL Server 2008


Windows Articles / All 34 Views comments

Teodor Nechita

by Teodor Nechita


Affiliate Disclosure

sql server

Microsoft’s SQL Server is a relational database administration system. Its essential perform is to retrieve knowledge as requested by different software program purposes.

These purposes might run both on the identical pc or on one other pc throughout a community, together with over the Web.

As you could already know, Microsoft ceased support for SQL Server 2008 and 2008 R2 again in 2019. That being stated, customers at the moment are pressured to improve in the event that they need to proceed utilizing the product securely.

That's the reason we’ve compiled this step-by-step information that may present you precisely how one can improve from SQL Server 2008 yo 2012, 2016, and so on.

Earlier than continuing with these steps, there are a number of issues that you might want to know concerning the improve course of:

  • Whenever you improve SQL Server, the earlier model of SQL Server might be overwritten
  • It's a good suggestion to again up any SQL Server knowledge you've got earlier than the improve
  • You can't improve SQL Server Categorical or SQL Server Developer, as these will not be supported

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

How do I improve from SQL Server 2008?

  1. Insert the SQL Server set up media
  2. Go to the basis folder, and double-click Setup.exe.
    • The Set up Wizard will now begin the SQL Server Set up Middle

      SQL Server Installation Center

  3. To improve an present occasion of SQL Server, choose Set up
  4. Click on an choice to point whether or not you're upgrading to a free version of SQL Server, or whether or not you've a PID key
  5. On the License Phrases web page, choose I settle for the license phrases
    • The Microsoft Replace web page will seem
  6.  Examine inside the Microsoft Replace web page to incorporate the newest updates whenever you scan for Home windows Replace
  7. Examine or uncheck the Embrace SQL Server product updates checkbox
    • This will depend on whether or not you need the newest updates or not
    • The setup ought to now begin downloading, extracting and putting in the setup information
  8. On the Choose Occasion web page, specify the occasion of SQL Server to improve
  9. On the Occasion Configuration web page, specify the Occasion ID for the occasion of SQL Server
  10. Click on Set up
  11. Restart your PC

By following these steps, it is best to have the ability to effectively improve from SQL Server 200eight.

Moreover, in case you remembered to again up all your knowledge earlier than continuing with the method, then you must have the ability to migrate it to the brand new OS with none points.

Remember that the identical course of applies when upgrading to later variations of the product as properly, similar to 2014, 2016, and so forth.

Did you discover this text helpful? Tell us within the remark part under.