Comments
3 comments
-
Official commentHi 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.
-
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 Retro Bowl
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.
Thanks for sharing! Let me ask: if I want to apply a filter to exclude multiple tables at once (for example: ENTDropDownListItem and ENTCategoryList), how should I configure the filter file to use in the Azure Release task?
-
I got it. The Options field in the Azure DevOps task does not support command-line switches like /Exclude. This field is meant for standard Redgate option subway surfers flags (e.g., IgnoreWhiteSpace, IncludeDependencies, etc.), not filtering switches.
Add comment
Please sign in to leave a comment.
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