Powershell invoke-sqlcmd from query in a txt file

Question

I have TSQL insert statements in a multiple text file in a folder. I need to run on sql server using foreach loop in powershell. it should go to each file in a folder read the query execute that and terminate the connection again read the next file and do the same operation

invoke-sqlcmd -ServerInstance KUMSUSHI7 -Query (Get-Content | For-each "C:\Drill\Task\SAMS Automation\Query.txt")

Please help me on this

vonPryz · Accepted Answer · 2015-03-10 11:45:09Z

6

Invoke-Sqlcmd can take script file as a parameter, so no -Query is needed. There's an example on MSDN:

Invoke-Sqlcmd -InputFile "C:\TestSQLCmd.sql" | Out-File -filePath "C:\TestSQLCmd.rpt"

Thus, get a list of your sql files and pass the file names to Invoke-Sqlcmd like so,

gci "c:\some\path\*" -include *.sql | % {
    Invoke-Sqlcmd -InputFile $_.FullName
}

edited Mar 10, 2015 at 11:45

answered Mar 10, 2015 at 8:55

vonPryz

24.3k10 gold badges58 silver badges69 bronze badges

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

Collectives™ on Stack Overflow

Powershell invoke-sqlcmd from query in a txt file

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