Friday, May 4, 2018

SQLServer dsc1

sl E:\SQLSaturday\

Configuration DSCModules
{
    param (
        [Parameter(Mandatory=$true)]
        [ValidateNotNullOrEmpty()]
        [String]
        $PackagePath
    )

Import-DscResource –ModuleName PSDesiredStateConfiguration

 Node $AllNodes.where{ $_.Role.Contains("SQLENGINE") }.NodeName
    {
        Log ParamLog
        {
            Message = "Running DSCModules deployment. PackagePath = $PackagePath"
        }


        #Copy the xSQLServer and xComputerManagement modules
        File CopyDSCModules {
            Ensure = "Present"
            Type = "Directory"
            Recurse = $true
            MatchSource = $true
            SourcePath = "$PackagePath\Modules"
            DestinationPath = "C:\Program Files\WindowsPowershell\Modules\"
        }
        }
    }

DSCModules -ConfigurationData E:\SQLSaturday\MyServerData.psd1 -PackagePath "\\LABDC\InstallMedia" -verbose

No comments:

Post a Comment