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

Redgate SQL Change Automation: Release Task in Azure DevOps Pipeline SQL Data Compare options Invalid DataCompare option

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 ==============================================================================

2025-04-14T20:07:27.8193273Z New-DatabaseConnection, SQL Change Automation 4.7.25036.5143, Copyright © Red Gate Software Ltd 2014-2025

2025-04-14T20:07:27.8315503Z

2025-04-14T20:07:27.8316632Z INFORMATION - Use of SQL Change Automation requires licensing in line with the Redgate End User License Agreement.

2025-04-14T20:07:27.8317810Z See Red-gate.com/EULA for more information.

2025-04-14T20:07:27.8318025Z

2025-04-14T20:07:28.1594542Z New-DatabaseReleaseArtifact, SQL Change Automation 4.7.25036.5143, Copyright © Red Gate Software Ltd 2014-2025

2025-04-14T20:07:52.6078068Z Creating SQL Source Control release artifact

2025-04-14T20:07:52.9734004Z ##[error]Invalid DataCompare option specified in SQLDataCompareOptions parameter: '/Exclude:table:\[dbo]\.\[ENTDropDownListItem]'

2025-04-14T20:07:53.6644414Z ##[section]Finishing: Perform Release Inv DB copy

Roman
0

Comments

1 comment

Sort by
  • Christian Perez
    Official comment

    Hi Roman,

    Thanks for reaching out to Redgate Support, as we have already had the pleasure of chatting I am going to put the answer from our investigation here for other users as well.

     

    In this case, the issue is due to the switch 

    /Exclude:table:\[dbo]\.\[ENTDropDownListItem] 

    from the command line 

    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" being passed

    Being passed in the options Parameter field of the Azure Release task. You cannot pass a command line switch in this field, so you either need to create a new filter file and pass it in the Filter File field, or continue using the command line option where you can pass the 

    /Exclude:table:\[dbo]\.\[ENTDropDownListItem] 

    Switch.

    Christian Perez

Add comment

Please sign in to leave a comment.