SSC and SQL Compare doesnt notice case changes

fpdave100

I’ve changed a udf from
ALTER FUNCTION [dbo].[CategoriesChildrenAsXMLGet]
:
ca.Guid AS 'GUID', ...
:
END

To

ALTER FUNCTION [dbo].[CategoriesChildrenAsXMLGet]
:
ca.Guid AS 'Guid',...
:
END

Thats the only change, and it does recognise it as a change on my case insensitive SQL server, even tho it is a significant change (its generating XML)

I have SSC v4.0.0.181 standard

There is the same problem (bug!) in Sql Compare 11.2.1.82 pro

It should treat literal values in schema case sensitively

Sergio R

Hi,

For SQL Source Control and SQL Compare to behave the way you wish, you will need to enable the Use case-sensitive object definition option.

Please let me know if this has answered your question.

Thank you,