Tests/Get-LegacyDataTestCredential.ps1
|
<#
.SYNOPSIS Get a stored set of credentials for testing this project. .LINK See https://www.jaapbrasser.com/quickly-and-securely-storing-your-credentials-powershell/ While Export- and Import-Clixml is pretty widely used, I took the basic structure of the XML file from Jaap Brasser's blog #> [CmdletBinding()] param() $FileDirectory = "${env:\userprofile}" $FileName = 'LegacyData.Tests.cred' $FilePath = Join-Path -path $FileDirectory -child $FileName $Hash = Import-CliXml -Path $FilePath Write-Verbose -Message "Read credentials from '$FilePath'" # I used this as a test, when coding this script # invoke-sqlcmd2 -ServerInstance localhost -Query 'select getdate() RightNow, @@servername sn' -Credential $Hash.User $Hash |