SQL 2017 bits are generally available to customers today. One of the most notable milestones in the 2017 release is SQL Server on Linux. Setup has been relatively simple for SQL Server on Linux, but often there are questions around unattended install. For SQL Server on Linux, there are several capabilities that are useful in unattended install scenarios:
-
You can specify environment variables prior to the install that are picked up by the install process, to enable customization of SQL Server settings such as TCP port, Data/Log directories, etc.
-
You can pass command line options to Setup.
-
You can create a script that installs SQL Server and then customizes parameters post-install with the mssql-conf
The sample script link seems like it’s broken, but you can see it all on Denzil’s Github repo.