How to detect that column case is different?

Discussion of open issues, suggestions and bugs regarding database management and development tools for SQL Server
Post Reply
davidhood
Posts: 1
Joined: Tue 09 Mar 2010 05:47

How to detect that column case is different?

Post by davidhood » Tue 09 Mar 2010 05:52

Hiiiiiiiiiiiiiiiiii................I am Davidhood
I am using version 1.50.336 of the Schema Compare for SQL Server and I have a question. We had to change the case of a number of fields in a table (ie. - "field1" to "Field1") when I do the comparison with the "Ignore case" option unchecked and the "Ignore extended properties" checked , the result of the compare is Equal for the table with the different case fields. Is this the expected result?

How do I get the comparison to recognize the table fields are different?

Duke
Devart Team
Posts: 476
Joined: Fri 29 Oct 2004 09:25

Post by Duke » Tue 09 Mar 2010 08:04

No, this is incorrect behavior. Version 2.0 shows this difference correctly.

Post Reply