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
Nesta página do site você pode assistir ao vídeo on-line How To Execute a SQL Script from Powershell duração hora minuto segundo em boa qualidade , que foi baixado pelo usuário The SQL Guy 03 Maio 2022, compartilhe o link com seus amigos e conhecidos, no youtube este vídeo já foi visto 11,268 vezes e gostou 42 espectadores. Boa visualização!
