Developer Workstation Role - SQL-FineBuild/Common GitHub Wiki

Previous Management Server Role Administration Server Role Next

This page describes the Developer Workstation Role deployment file.

The assumptions relating to this role are:

  • Each developer has their own personal workstation
  • SQL Server is one of many software components that will be installed, so SQL memory must be limited to 800MB
  • All software will be installed on the System drive
  • The default SQL Server account names will be used for all services

  1. Create a role file in the Site SQL Files Folder similar to the example below. Call the file SQLWorkstation.bat.

    The role file contains all the parameters that define the role.

  REM Copyright FineBuild Team © 2014 - 2016.  Distributed under Ms-Pl License
  REM
  CALL "SQLDev.bat" %*           /Type:Workstation             ^
   /IAcceptLicenseTerms          /Edition:Dev                  ^
   /SAPWD:"UseAL0ngPa55phrase!"  /spConfigureMaxServerMemory:800

  1. In this example, it is not necessary to create an install file for each server, as there are no server-specific items.

  2. When the SQLWorkstation file is run, it runs the environment default values file which in turn invokes FineBuild with the combined set of parameters.

Copyright FineBuild Team © 2014 - 2018. License and Acknowledgements

Previous Management Server Role Top Administration Server Role Next