How to upgrade SQL2016 Developer Edition to 2019 Developer Edition using PowerShell Script

Question

How to upgrade SQL2016 Developer Edition to 2019 Developer Edition using PowerShell Script

Jesalpura, Bhupendrakumar G. (TR Technology) 41

How to upgrade SQL2016 Developer Edition to 2019 Developer Edition using PowerShell Script.
We are not using default instance name = MSSQLSERVER

CarrinWu-MSFT 6,891 Reputation points

2021-06-02T05:43:44.057+00:00

Hi @Jesalpura, Bhupendrakumar G. (TR Technology) , we have not get a reply from you. Did any answers could help you? If there has an answer helped, please do "Accept Answer". If not, please let us know. By doing so, it will benefit for community members who have this similar issue. Your contribution is highly appreciated. Thank you!

Accepted answer

1 additional answer

Your answer

CarrinWu-MSFT 6,891 Reputation points

2021-06-02T05:43:44.057+00:00

Hi @Jesalpura, Bhupendrakumar G. (TR Technology) , we have not get a reply from you. Did any answers could help you? If there has an answer helped, please do "Accept Answer". If not, please let us know. By doing so, it will benefit for community members who have this similar issue. Your contribution is highly appreciated. Thank you!

Answer 1

Hi @Jesalpura, Bhupendrakumar G. (TR Technology) ,

Welcome to Microsoft Q&A!

Same question with Olaf. You should download SQL Server 2019, and then you could select the instance which you would like to upgrade:

If I have misunderstand your question, please let me know.

Best regards,
Carrin

If the answer is helpful, please click "Accept Answer" and upvote it.
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.

Answer 2

Olaf Helper 47,416

Why with a PowerShell script; a simple batch do the job (which can be started from PowerShell)?
See
Install SQL Server from the Command Prompt
Install SQL Server using a configuration file

Jesalpura, Bhupendrakumar G. (TR Technology) 41 Reputation points

2021-05-28T11:29:38.64+00:00

Would you please provide me batch file or configuration file to upgrade SQL Server 2016Developer Edition to SQL 2019 DEveloper Edition with instance name = I1 . with selected features need to be upgrade.
Tom Phillips 17,771 Reputation points

2021-05-28T12:48:53.047+00:00

There is no difference when upgrading based on "edition" used. The same options are used for every upgrade.

Please see:

https://learn.microsoft.com/en-us/sql/database-engine/install-windows/install-sql-server-from-the-command-prompt?view=sql-server-ver15#Upgrade
Olaf Helper 47,416 Reputation points

2021-05-28T13:18:29.657+00:00

Do one upgrade manually with the installation wizard and set all wanted parameter, at the very last page of the wizard it create a config (ini) file for the installation, the link to it is shown at the bottom of the page; you can INI file.
Olaf Helper 47,416 Reputation points

2021-06-02T06:24:05.887+00:00

Would you please provide me batch file or configuration file to upgrade

Follow the installation wizard, as in your screenshot and when you get the the last step "Complete" you will find at the bottom of the form a link to the generated INI configuration file, which you can use for further installations.

Share via

How to upgrade SQL2016 Developer Edition to 2019 Developer Edition using PowerShell Script

1 additional answer

Your answer