SQL 명령행 설치 예

Setup.exe /QS /ConfigurationFile=SQLInstall.ini

 

#SQLInstall.ini

; Microsoft SQL Server 2012 Configuration file
[OPTIONS]
ACTION="Install"
IACCEPTSQLSERVERLICENSETERMS
FEATURES="SQLEngine,FullText,Replication.Tools"
INSTANCEDIR="C:\MSSQLSERVER"
INSTANCENAME="TEST"
INSTANCEID="TEST"
ROLE="AllFeatures_WithDefaults"
SAPWD="password*123456"
SECURITYMODE="SQL"
SQLSVCSTARTUPTYPE="Automatic"
AGTSVCSTARTUPTYPE="Automatic"
UpdateEnabled=True
UpdateSource="N:\SQL2012SP1Patch"

이 정도면 일반 설치에는 문제 없을듯...

 

[ACTION] 에는 아래와 같은 파라미터 사용 가능.

None
RemovePatch
Uninstall
Install
Upgrade
Patch
Repair
LandingPage
ClusterReport
RunRules
PrepareFailoverCluster
CompleteFailoverCluster
InstallFailoverCluster
RemoveNode
AddNode
EditionUpgrade
Bootstrap
ComponentUpdate
Help
RebuildDatabase
RunDiscovery
PrepareImage
CompleteImage

 

설치후, Patch 업데이트는,.
<package>.exe /qs /IAcceptSQLServerLicenseTerms /Action=Patch /InstanceName="TEST"

삭제는,.
Setup.exe /Action=Uninstall /FEATURES=SQL,AS,RS,IS,Tools /INSTANCENAME="TEST"