Upgrading SQL 2012 to 2017

mohdashraf azam 21 Reputation points
2021-01-27T08:49:44.897+00:00

Hello.

i have windows server 2012 r2 and it is running SQL server 2012 Enterprise. I want to upgrade SQL 2012 to 2017/2016. Do i need to purchase any license for this upgrade and can i use the same server for upgrade to i have to prepare new server for this upgrade.
thanks.

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,153 questions
Transact-SQL
Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,665 questions
0 comments No comments
{count} votes

Accepted answer
  1. Olaf Helper 45,366 Reputation points
    2021-01-27T09:22:24.06+00:00

    Hello,

    SQL Server licenses are bound to the version. If you want to upgrade to a new version, then you have to purchase new licenses.

    You can perform an in-place migration, then everything stays the same, only SQL Server is a new version.


1 additional answer

Sort by: Most helpful
  1. CathyJi-MSFT 22,331 Reputation points Microsoft Vendor
    2021-01-27T10:18:46.527+00:00

    Hi @mohdashraf azam ,

    > Do i need to purchase any license for this upgrade

    Yes, you need to buy SQL server 2016 Enterprise license key or SQL server 2017 Enterprise license key when you upgrade SQL 2012 enterprise to SQL 2017\2016 enterprise.

    > and can i use the same server for upgrade to i have to prepare new server for this upgrade.

    Yes, you can use the same server windows 2012 R2. Do a SQL server in-place upgrade. Please refer to the blog How to Upgrade SQL Server 2012 / 2014 to SQL Server 2016 to get detail steps.

    Bes regards,
    Cathy


    If the response is helpful, please click "Accept Answer" and upvote it, thank you.

    1 person found this answer helpful.
    0 comments No comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.