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

SSC and SQL Compare doesnt notice case changes

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
fpdave100
0

Comments

1 comment

Sort by
  • 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,
    Sergio R
    0

Add comment

Please sign in to leave a comment.