Examples/SQLServerScript.ps1

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
configuration SQLSettings
{   
    Import-DscResource -ModuleName 'xSQLServer'

    Node 'localhost'
    { 
        xSQLServerScript SqlSettings
        {
            ServerInstance = "$env:COMPUTERNAME\SMA"
            SetFilePath = "C:\temp\Set-SQlsettings.sql"
            TestFilePath = "C:\temp\Test-SQlsettings.sql"
            GetFilePath = "C:\temp\Get-SQlsettings.sql"
            Variable = @("FilePath=C:\temp\log\AuditFiles")
        } 
    } 
}

$configData = @{ 
    AllNodes = @(  
        @{ 
            NodeName = 'localhost'
        }
    ) 
}

SQLSettings -ConfigurationData $configData

Start-DscConfiguration -Path .\SQLSettings -Wait -Force -Verbose