Hopefully you’ve seen over the last two posts some basic techniques for automating and codifying your SQL Server builds. There’s just two more items I want to cover here, questions you’re probably asking yourself already.
The build script
Let’s start with reviewing the whole build script to this point. While I wouldn’t recommend running this in production yourself, the finalized version looks something like this:
Run this from the install binary location [Reflection.Assembly]::LoadWithPartialName(“System.Web”) $SAPassword = [System.Web.Security.Membership]::GeneratePassword(16,4) .\setup.exe /CONFIGURATIONFILE=<config file location> /SAPASS