Examples/Resources/xSQLServerScript/1-RunScriptUsingSQLAuthentication.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
30
<#
.EXAMPLE
    This example shows how to run SQL script using SQL Authentication.
#>


Configuration Example
{
    param(
        [Parameter(Mandatory = $true)]
        [PSCredential]
        $SqlCredential
    )

    Import-DscResource -ModuleName xSQLServer

    Node localhost
    {
        xSQLServerScript 'RunSQLScript'
        {
            ServerInstance = 'localhost\SQL2016'
            Credential     = $SqlCredential

            SetFilePath    = 'C:\DSCTemp\SQLScripts\Set-RunSQLScript.sql'
            TestFilePath   = 'C:\DSCTemp\SQLScripts\Test-RunSQLScript.sql'
            GetFilePath    = 'C:\DSCTemp\SQLScripts\Get-RunSQLScript.sql'
            Variable       = @("FilePath=C:\temp\log\AuditFiles")
        }
    }
}