PSCI

1.1.0

dsc/ext/PsGallery/xSQLServer.7.0.0.0/Examples/Resources/xSQLServerScript/1-RunScriptUsingSQLAuthentication.ps1

                                <#

.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")

        }

    }

}