What are the challenges you face when working across database platforms? Take the survey

SSC and SQL Compare doesnt notice case changes

fpdave100fpdave100 Posts: 12 Bronze 1
edited November 9, 2015 9:20AM in SQL Compare 11
I’ve changed a udf from
ALTER FUNCTION [dbo].[CategoriesChildrenAsXMLGet]
ca.Guid AS 'GUID', ...


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

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 pro

It should treat literal values in schema case sensitively


  • Options

    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,
    Product Support Engineer
    Redgate Software Ltd
    Please see our Help Center for detailed guides on how to use our tools
Sign In or Register to comment.