Specify partial directory to use in Powershell Invoke sqlcmd

Question

Need to be able to run .sql files individually that are located in multiple sub directories. This script will be ran on multiple computers where the directory wont be the same but the sub directories will be. So I want to be able to define the directory as a variable like this.

$Path = 'D:\Source\Database'
invoke-sqlcmd -Username $username -Password $password -inputfile "$Path*\SQLServer\create_types.sql" -serverinstance "localhost" -database "test" | Out-File -FilePath "c:\testoutput.txt"

TheMadTechnician · Accepted Answer · 2016-02-24 20:00:48Z

2

Use Get-ChildItem with -recurse and pipe into a ForEach loop.

$Path = 'D:\Source\Database'
Get-ChildItem "$Path\*\SQLServer\create_types.sql" -recurse|ForEach{
    invoke-sqlcmd -Username $username -Password $password -inputfile $_.FullName -serverinstance "localhost" -database "test"
} | Out-File -FilePath "c:\testoutput.txt"

answered Feb 24, 2016 at 20:00

TheMadTechnician

36.5k3 gold badges48 silver badges63 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Specify partial directory to use in Powershell Invoke sqlcmd

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related