How can I write a power shell code to call a .sql file?

Question

I have a couple .sql scripts. I want to write a wrapper function/script to call and run all of those .sql files. It can be either in sql or powershell.

I appreciate any help.

What do you mean by either SQL or Powershell? If you want to run in SQL, you can add all scripts(.sql) to stored proc. — Jigar
– Jigar, Commented Jul 30, 2015 at 15:16
I mean I need to write a script either with sql or powershell. — kimitrio
– kimitrio, Commented Jul 30, 2015 at 15:25

Kristián Stroka · Accepted Answer · 2015-07-30 15:17:38Z

2

Get-ChildItem -Path "path_to_folder_with_scripts" -Filter "*.sql" | % {invoke-sqlcmd -InputFile $_.FullName}

Edit path_to_folder_with_scripts to your path to folder with sql files

answered Jul 30, 2015 at 15:17

Kristián Stroka

7381 gold badge10 silver badges28 bronze badges

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

2 Comments

kimitrio Over a year ago

This only shows the sql files in folder. I need to run them.

Ben Thul Over a year ago

@kimitrio: that's what the pipe to invoke-sqlcmd does.

Collectives™ on Stack Overflow

How can I write a power shell code to call a .sql file?

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related