search

DrJohnT / AzureDevOpsExtensionsForSqlServer

Microsoft SQL Server deployment extensions for Azure DevOps Pipelines
MIT License
21 stars 14 forks source link

RunSqlCmdScripts Feature Request: Log/Output file #4

Open RajAdusumalli opened 5 years ago

RajAdusumalli commented 5 years ago

Hi John,

Thank you so much for creating this very useful extension. Is it possible for you to add an option to add logging capabilities for each file to a specific location?

FYI, I tried using the Invoke-Sqlcmd from powershell with outputas param specified but no output is recorded for the Insert and Update statements (rows affected). Any help would be appreciated.

DrJohnT commented 5 years ago

I will take a look when I get back from holiday

DrJohnT commented 3 years ago

@rajhii Are you talking about this option for Invoke-Sqlcmd? Example 2: Invoke commands in a script file and save the output in a text file