SQL Server command line installs

j-man

Does anyone do them regularly? I've never done one in production but going through the 70-462 book again, they have you doing them a lot.

That being said, there are a lot of switches that can be used and I'm wondering if anyone has a preferred order they place the switches? Or if you're forced to do a command line install, do you put them in willy nilly?

aaronchristenson

I have to say, I have never done a command line install. I guess you might want to do one if you were installing SQL Server in Windows Server core, but even then I would not want to do it that way. When I took that test I do not remember any questions about doing installs by command line, granted when I took the exam it was still in beta.

knownhero

All the installs I've personally done haven't been via command line. If I was to use anything it would be the configuration file in PowerShell:

import module servermanager

add-windowsdeature as-net-framework


MD "C:\Program Files (x86)\Microsft SQL Server\DReplayClient\ResultDir"
MD "C:\Program Files (x86)\Microsft SQL Server\DReplayClient\WorkingDir"
	
d:\setup.exe /configurationfile="c:\configurationfile.ini"

Something like the above as shown in the Trainsignal videos would be better.

j-man

Thanks guys!