Skip to content

Folder Setup

Jump to bottom
Jason Carter edited this page Aug 24, 2016 · 16 revisions

Required

Optional

Common

The common folder contains all the Powrshell Commandlets used to execute the Install.

PreScripts

The PreScript folder holds PowerShell file meant to Configure or Check your System prior to install. There are many examples in this repository of various operations that you may wish to employ.

PostScripts

The PostScript folder holds PowerShell or SQL files that are used to configure your SQL instance AFTER a successful install. All files will be executed in the context of the installers credentials.

Templates

This folder holds Base Configurations for each version of SQL. As each version of SQL has varying items, we can address those items by simply modifying the template for that version.

Command Line Configuration options for SQL can be found here: https://msdn.microsoft.com/en-us/library/ms144259.aspx

SQL Folders

In the original methodology, you would create a folder for each version of SQL directly in the SPADE folder, thus you might see:

  • SPADE
    • Common
    • PreScript
    • PostScript
    • SQL2005
    • SQL2008
    • SQL2008R2

With that addition of the 'BinaryPath' attribute of the DataCenter node, we can now separate SQL from SPADE. These locations can even be on completely different servers. You could hold SPADE on a central server, while allowing the Binaries to be location dependent.

If the BinaryPath option is missing, it will revert to classic behavior by looking in the FilePath location. In the below example, Data Center 1 will use the classic example, while the 'Local' DataCenter will use a separate location for each item:

<DataCenters>
    <DataCenter Name="Data Center 1" Location="Location 1" FilePath="\\alfkidc-2\DataCenter1\AutoInstall\" />
    <DataCenter Name="Local" Location="Local" FilePath="C:\Code\sqlspade\" BinaryPath="C:\Code\MSSQL\" />
</DataCenters>

  • SPADE

    • Common
    • PreScript
    • PostScript

  • SQL

    • SQL2005
    • SQL2008
    • SQL2008R2

Service Packs

Path to Binaries:

  • Binary Path Defined: DataCenter.BinaryPath\Edition.FolderName

  • Binary Path UnDefined: DataCenter.FilePath\Edition.FolderName

  • Service Pack handling - in the works.

`

Clone this wiki locally