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

Azure DevOps - Deploy data with case sensitive comparison

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.
Marco_S
0

Comments

2 comments

Sort by
  • MikielAgutu
    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
    MikielAgutu
    0
  • Monday
    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.
    Monday
    0

Add comment

Please sign in to leave a comment.