SqlServerDsc

12.4.0.0

Examples/Resources/SqlScriptQuery/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
    {
        SqlScriptQuery 'RunAsSqlCredential'
        {
            ServerInstance = 'localhost\SQL2016'
            Credential     = $SqlCredential

            SetQuery       = 'Set query'
            TestQuery      = 'Test query'
            GetQuery       = 'Get query'
            Variable       = @('FilePath=C:\temp\log\AuditFiles')
        }
    }
}