This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(102.4, 70%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERP%3C/text%3E%3C/svg%3E)
I have windows server 2012 R2 running SQL Server 2016
As per our applications team we need to upgrade to Sql Server 2017 or higher which will work only on Windows Server 2016 or later.
What is the best way to do this?
Additional SQL Server features and topics not covered by specific categories
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(28.799999999999997, 2%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESX%3C/text%3E%3C/svg%3E)
Hi @Romit Poladiya ,
We have not received a response from you. Did the reply could help you? If the response helped, do "Accept Answer". If it doesn't work, please let us know the progress. By doing so, it will benefit all community members who are having this similar issue. Your contribution is highly appreciated.
Best regards,
Seeya
Hi @Romit Poladiya ,
In order to benefit all community members who are having this similar issue, please choose an answer to accept or vote for the answer you think is useful to you. Your contribution is highly appreciated.
Best regards,
Seeya
Hi there,
install win server 2022
then install sql server 2017 or higher (I'd recommend to go for the most recent version, eg SQL2022)
And then you can utilize the powershell module dbatools, which can do the heavy lifting for you:
https://docs.dbatools.io/Start-DbaMigration
BR,
Dirk
I am creating a windows server 2022 and then planning to upgrade to sql server 2017 there. Although this will be a challenge, any help / adivse on this will be really appreciated
Hi @Romit Poladiya ,
Hope everything goes well. If you plan to use SQL Server on Windows Server 2022, then you might as well use the latest SQL Server 2022 or 2019.
Best regards,
Seeya
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(67.2, 68%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELT%3C/text%3E%3C/svg%3E)
Hello
Thank you for your question and reaching out. I can understand you are having query\issues related to SQL upgrade.
Additionally , I would recommend to upgrade or switch from Window server 2012 R2 to 2019/2022 as after some time you may have to consider for this as well. Because Windows 2012 R2 also no longer supported or have limited support.
--If the reply is helpful, please Upvote and Accept as answer--
Hi @Romit Poladiya ,
If you continue to use Windows server 2012 R2, It is recommended that you update to SQL Server 2017. As you know, SQL Server 2019 or 2022 can only be installed on Windows Server 2016 and greater version.
Please follow these steps to update: To upgrade to a different edition of SQL Server
What's more, please check these documents about hardware and software requirement:
Operating System support for SQL Server 2017
SQL Server 2019: Hardware and software requirements
SQL Server 2022: Hardware and software requirements
Best regards,
Seeya
If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
