Activity overview
Latest activity by Frinslazince
I am using Redgate SQL Change Automation: Release Task in Azure DevOps Pipeline.
I entered an option into “SQL Data Compare options” field and my pipeline is failing with “Invalid DataCompare option” error. This option works fine on the SQLDataCompare.exe command line.
The option is /Exclude:table:\[dbo]\.\[ENTDropDownListItem]
And below works fine
sqldatacompare.exe /scripts1:"C:\Users\XXXXXXXXX\source\repos\EMS Phase 2\DB\Inv" /database2:"Inv" /server2:"localhost" /Exclude:table:\[dbo]\.\[ENTDropDownListItem] /ScriptFile:"C:\temp\SyncScript_exclude_ENTDropDownList.sql"
2025-04-14T20:07:11.4693110Z ##[section]Starting: Perform Release Inv DB copy
2025-04-14T20:07:11.6336679Z ==============================================================================
2025-04-14T20:07:11.6337193Z Task : Redgate SQL Change Automation: Release
2025-04-14T20:07:11.6338331Z Description : Safely deploy database changes with Redgate SQL Change Automation
2025-04-14T20:07:11.6338649Z Version : 4.2.4
2025-04-14T20:07:11.6338796Z Author : Redgate Software
2025-04-14T20:07:11.6339016Z Help : [More Information](https://www.red-gate.com/sca/ps/help/)
2025-04-14T20:07:11.6339226Z
Sounds like the pipeline task doesn’t accept the same option format as the CLI slope— maybe try adjusting the syntax or check which options are officially supported in the Release Task. / comments
I am using Redgate SQL Change Automation: Release Task in Azure DevOps Pipeline.
I entered an option into “SQL Data Compare options” field and my pipeline is failing with “Invalid DataCompare opti...