SQL Server Command Line Install – Change Edition

installationscriptingsql serversql-server-2016

I am creating a script to install SQL Server via the command line.

I cannot see a way to choose the edition I want to install. The GUI on my install media offers Evaluation, Developer or Express:

(When I choose Evaluation, I can enter the product code)

enter image description here

The ConfigurationFile.ini generated by the installer does not seem to have any sort of reference to the edition that is being installed. Once I run the installer, it installs standard edition (verified by PRINT @@version)

How can I specify the edition I wish to install?

Best Answer

I found some information about your question.

There is a parameter when you set up on the command line which is /PID.

Check out the document.

Specifies the product key for the edition of SQL Server. If this parameter is not specified, Evaluation is used.

C:\SQLMedia\SQLServer2019> setup.exe /Q 
/IACCEPTSQLSERVERLICENSETERMS /ACTION="install" 
/PID="AAAAA-BBBBB-CCCCC-DDDDD-EEEEE" /FEATURES=SQL,AS,IS,Tools
/INSTANCENAME=MSSQLSERVER /SQLSVCACCOUNT="MyDomain\MyAccount"

You can use this parameter with the product key.

Evaluation: 00000-00000-00000-00000-00000

Express: 11111-00000-00000-00000-00000

Developer: 22222-00000-00000-00000-00000

Excerpt from the blog of Pinal Dave.

Related Question