Extract sql server 2017 install file with Powershell

Question

I would like to download the sql server 2017 install file from Microsft, link: https://go.microsoft.com/fwlink/?linkid=853017 and if you also download this file you will notice that this is just a 4.8 mb file. When running it, and select to download the media for the full install, it will download a 700 mb file called "SQLEXPRADV_x64_ENU.exe"

While this is an exe, it basically just unzips all its contents.

I have tried to use Powershell to silently unzip:

start-process C:\SQLEXPRADV_x64_ENU.exe -Argumentlist "/a"

however it still brings up the prompt asking me to select zip location.

Is there a way to unzip this file silently (i.e just supply the desired path and automate it all from PS)?

*Edit: This is an environment where I wouldn't be able to use 7zip

Using start-process is the same as calling the executable directly: C:\SQLEXPRADV_x64_ENU.exe /extract: c:\temp. — Panagiotis Kanavos
– Panagiotis Kanavos, Commented Dec 21, 2017 at 13:58

Draken · Accepted Answer · 2019-09-06 09:12:47Z

1

100% worked

SQLEXPRADV_x64_ENU.exe /extract /X:"%TEMP%\mssql" /q && ping 127.0.0.1 -n 30 && %TEMP%\mssql\setup.exe /ACTION=Install

edited Sep 6, 2019 at 9:12

Draken

3,19614 gold badges38 silver badges56 bronze badges

answered Sep 6, 2019 at 8:52

user3400760

253 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

user847990 · Accepted Answer · 2017-12-21 13:46:45Z

0

It is not possible to script out the extracting of the full installation media for SQL Server Express. The purpose of that file is for user and ease of installation, it was not designed for strict script install.

If you are looking to get the media for doing an automated installation of SQL Server Express, then simply run the extract one time and you have it. Once the media is extracted then you can copy that directory and work on automating the installation.

answered Dec 21, 2017 at 13:46

user847990

Comments

Palle Due · Accepted Answer · 2017-12-21 11:19:18Z

0

You can try

start-process "C:\SQLEXPRADV_x64_ENU.exe" -Argumentlist "/extract: `"c:\temp`""

answered Dec 21, 2017 at 11:19

Palle Due

6,3224 gold badges22 silver badges36 bronze badges

1 Comment

Panagiotis Kanavos Over a year ago

Using start-process is the same as calling the executable directly: C:\SQLEXPRADV_x64_ENU.exe /extract: c:\temp. Besides, you can't extract the full installer from the web installer

Damon · Accepted Answer · 2019-02-06 20:16:46Z

0

Try this c:\SQLEXPRADV_x64_ENU.exe /X /q

answered Feb 6, 2019 at 20:16

Damon

11 bronze badge

Collectives™ on Stack Overflow

Extract sql server 2017 install file with Powershell

4 Answers 4

Comments

Comments

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

Comments

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related