SqlServerDsc

13.1.0.0

Examples/Resources/SqlScript/1-RunScriptUsingSQLAuthentication.ps1

<#
.EXAMPLE
    This example shows how to run SQL script using SQL Authentication.
#>

Configuration Example
{
    param(
        [Parameter(Mandatory = $true)]
        [System.Management.Automation.PSCredential]
        $SqlCredential
    )

    Import-DscResource -ModuleName SqlServerDsc

    Node localhost
    {
        SqlScript 'RunAsSqlCredential'
        {
            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')
        }
    }
}