Case Sensitive Data migration

Dominick

I am currently using TFS and SQL Change Automation as part of my CI/CD pipeline.  As part of this process, we are moving Static Data.  Is there any way for SCA to move the static data and force case sensitivity?  So that if we have data in a table that says "TEST" in our source database, and "test" in a higher environment, it would flag them as different and push the change?
I have not found a way to do this yet, and it is critical as we have values in our static data that needs to display on client reports.
 (and sorry if this has been asked before, I could not find it)
Thanks
Dominick

Sergio R

Starting with version 3.3 of SQL Change Automation Powershell you can now use SQL Data Compare options. There is a SQL Data Compare option that enables Case Sensitivity in data, ForceBinaryCollation.

However that option is not available on the TFS\Azure DevOps add-on yet, so to do this currently you would need to switch to a Powershell step.

For example:

New-DatabaseReleaseArtifact -Source "Your Build Artifact" -target "Your target database" -SQLDataCompareOptions "ForceBinaryCollation"

Dominick

Thanks Sergio, any idea if this is in the backlog for the Add-On, and if so, is there a rough time frame as to when it will be delivered? 

Sergio R

This should be added very soon, possibly in the next few weeks.

Please keep an eye on the release notes for the Azure DevOps add-ons:
https://documentation.red-gate.com/sca3/release-notes-and-other-versions/add-on-release-notes