Azure DevOps - Deploy data with case sensitive comparison

Marco_SMarco_S Posts: 5 New member
edited April 12, 2019 9:39PM in SQL Change Automation
Hi

I'm trying to deploy data from a nuget package using Azure DevOps. Stuff works well for most changes. Now we also need to apply text changes (row data, not schema), if only casing is different ("my Text" before, "My Text" after). It does not look like you can set the option ForceBinaryCollation in the Azure DevOps Release task.

Is it possible to achieve somehow?

Thanks for any hint.
Tagged:
· Share on Twitter

Answers

  • MikielAgutuMikielAgutu Posts: 29 Silver 1
    Hello Marco

    Unfortunately SQL Change Automation doesn't support setting SQL Data Compare options from Azure DevOps tasks, or the PowerShell cmdlets themselves. However SQL Data Compare option support is currently on our backlog and work is scheduled to start soon. I can't give a definite time frame for when it will be released however.

    Thanks
    Mikiel Agutu | Software Engineer | Redgate Software
    · Share on Twitter
  • MondayMonday Posts: 77 Silver 3
    SQL Data Compare option support is currently on our backlog and work is scheduled to start soon.

    This is great news! I am also interested in defining which columns in a table are used or can be ignored for data compare.
    · Share on Twitter
Sign In or Register to comment.