How can we help you today? How can we help you today?
Frinslazince

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...
Edited 0 votes