How to validate SQL scripts without executing in PowerShell

Question

I was trying to validate all my SQL files using the below scripts but somehow its throwing an error. Need help.

cd D:\My_System\rgbumerch\test

Get-ChildItem .\*.sql | Select -ExpandProperty FullName | ForEach { $query = (Get-Content -Path $_); Check-Query-Syntax $str }

Error:

Check-Query-Syntax : The term 'Check-Query-Syntax' is not recognized as the name of a cmdlet, function, script file, or operable program. Check the spelling of the name, or if a path was included, verify that the path is correct and try again.

At line:2 char:102
+ ... ForEach { $query = (Get-Content -Path $_); Check-Query-Syntax $str }
+ ~~~~~~~~~~~~~~~~~~
+ CategoryInfo : ObjectNotFound: (Check-Query-Syntax:String) [], CommandNotFoundException
+ FullyQualifiedErrorId : CommandNotFoundException

What is Check-Query-Syntax supposed to be?

Doug Maurer
– Doug Maurer

2021-07-05 21:29:35 +00:00
Commented Jul 5, 2021 at 21:29 — Doug Maurer
– Doug Maurer, Commented Jul 5, 2021 at 21:29
.. and $str is also undefined..

Theo
– Theo

2021-07-06 18:51:00 +00:00
Commented Jul 6, 2021 at 18:51 — Theo
– Theo, Commented Jul 6, 2021 at 18:51

alexzelaya · Accepted Answer · 2021-07-07 03:04:39Z

2

Try replacing Check-Query-Syntax $str for this Check-Query-Syntax $query

answered Jul 7, 2021 at 3:04

alexzelaya

2551 silver badge8 bronze badges

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

1 Comment

alexzelaya Over a year ago

Also, can you please share how the function Check-Quey-Syntax is declared or how you import the module?

Collectives™ on Stack Overflow

How to validate SQL scripts without executing in PowerShell

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related