Examples/Resources/SqlScript/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 SqlServerDsc Node localhost { SqlScript '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") } } } |