How To Execute a SQL Script from Powershell

In this tutorial we look at how to execute a SQL script from Powershell. I cover how to use both powershell ISE and Powershell CMD.

Lesson Format

00:00 Tutorial overview
00:43 Executing SQL with Powershell script
02:00 Catching Errors and Logging
04:25 Using Powershell CMD

Creating the SQL Table

In the tutorial I go over how to create a SQL Table with a timestamp column that shows when the record was inserted. This is good for both demonstrating that the script is actually doing what I want it to, but also highlighting when the record is inserted.

Along with the Create Table syntax, I also show the relevant INSERT statement we are using and save the file along with the Powershell script.

Powershell Script

The powershell script is simple Invoke-sqlcmd cmdlet. This passes in the database instance along with the server name and an input file. Later in the tutorial we look at how add logging within this also.

Its really nice and simple - just 3 lines of code (it could even be done in 1!)

Logging errors

Within the tutorial I also look at how to catch any errors that may occur while we run the script, we may be automating this process and have it running on a schedule for example. To do this we can create a nice log file which captures any errors which we could potentially check should we not be getting the required results.

Requests

If there is anything else that you need or want answered then please let me know and I can get it answered or a video made.

Thanks - please Like and Subscribe