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

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', ...
:
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

Comments

  • Options
    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
    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.