Activity overview
Latest activity by lyly19
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? / comments
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 ca...