How to catch error from sql server on powershell?

Question

I have written powershell script that executes all sql from folder, but I want to stop executing on error? Is it possible to catch the error with powershell that was happened on SQL server? This is powershell code

function runSqlScript{
    param([string]$sqlPath) 
    $connection = New-Object System.Data.SqlClient.SqlConnection
    $connection.ConnectionString = $connectionString.connectionString
    $connection.Open()
    $command = $connection.CreateCommand()
    $command.CommandText = Get-Content $sqlPath
    $command.ExecuteNonQuery()
    $connection.Close()
}

function runScriptsFromFolder{
    param( [string]$pathToFolder)
    Get-ChildItem $pathToFolder -Filter *.sql| ForEach-Object {
        runSqlScript($_.FullName)
    }
}

Powershell supports try/catch/finally. See msdn.microsoft.com/en-us/powershell/reference/5.1/… — Dan Guzman
– Dan Guzman, Commented May 6, 2017 at 17:59

Dan Guzman · Accepted Answer · 2017-05-07 11:44:20Z

3

Powershell supports try/catch/finally. This allows you detect and handle errors within the scope of try block.

If you simply want to stop the PS script if any errors occur, including non-SQL errors, wrap the main code in a try block:

try {
    runScriptsFromFolder -pathToFolder "C:\SqlScripts"
}
catch {
    throw
}

answered May 7, 2017 at 11:44

Dan Guzman

29.1k2 gold badges47 silver badges71 bronze badges

Add a comment |

Stack Exchange Network

How to catch error from sql server on powershell?

1 Answer 1

Your Answer

Hot Network Questions

How to catch error from sql server on powershell?

1 Answer 1

Your Answer

Sign up or log in

Post as a guest

Related

Hot Network Questions