I created a Release in VSTS and when the release runs I am not finding any good information on what was released in each environment.
Prior to the upgrade I'm pretty certain it output which scripts were getting executed, etc. Maybe it still is and I am not finding it. This looks to be the extent of the logging I am finding:
##[section]Starting: Deploy database changes
Task : Redgate SQL Change Automation: Release
Description : Safely deploy database changes with Redgate SQL Change Automation
Version : 3.0.1
Author : Redgate Software
Preparing task execution handler.
Executing the powershell script: W:\Builds\VstsModernizationReleaseAgent1\_tasks\RedgateSqlChangeAutomationRelease_c1177c17-3934-4005-ba89-a4549fe4f0a1\3.0.1\RunSqlChangeAutomation.ps1
New-DatabaseConnection, SQL Change Automation 220.127.116.112, Copyright c Red Gate Software Ltd 2014-2018
Use of this functionality requires a SQL Toolbelt license.
If you are unsure of your current user license entitlement please contact [email protected]
Test-DatabaseConnection, SQL Change Automation 18.104.22.1682, Copyright c Red Gate Software Ltd 2014-2018
New-DatabaseReleaseArtifact, SQL Change Automation 22.214.171.1242, Copyright c Red Gate Software Ltd 2014-2018
Use-DatabaseReleaseArtifact, SQL Change Automation 126.96.36.1992, Copyright c Red Gate Software Ltd 2014-2018
##[section]Finishing: Deploy database changes
Is there anyway to see which scripts are being deployed?