PowerShell

DevOps & Tools PowerShell SQL Server & Data

Use Power Shell to execute SQL Server script files
November 26, 2015August 1, 2026

Below is the snippet for using Power Shell to execute list of SQL scripts under a specific folder. I use this script in Octopus deployment to deploy database changes (* for this particular case, we don’t…

Read article Use Power Shell to execute SQL Server script files
DevOps & Tools PowerShell

Reading multiple lines using Powershell
November 26, 2015August 1, 2026

by default, Get-Content in powershell reading the file as a one long string. which means you might have an issue if you have multiple lines of SQL statements as it will read this IF EXISTS(SELECT 1…

Read article Reading multiple lines using Powershell