Red Gate forums :: View topic - Will SQL Source Control identify a case change?
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Source Control 1
SQL Source Control 1 forum

Will SQL Source Control identify a case change?

Search in SQL Source Control 1 forum
Post new topic   Reply to topic
Jump to:  
Author Message
troyhunt



Joined: 28 Nov 2010
Posts: 15
Location: Australia

PostPosted: Sun Nov 28, 2010 3:42 am    Post subject: Will SQL Source Control identify a case change? Reply with quote

I just made a number of case only changes (just column names) to a DB under source control and noticed SQL Source Control didn't pick them up (no changes to commit).

Will the tool natively identify changes in case? Is it dependent on the collation of the DB? These names are persisting through to an ORM so the case becomes pretty important at compile time.
Back to top
View user's profile Send private message
chriskelly



Joined: 19 Apr 2010
Posts: 309
Location: Cambridge, UK

PostPosted: Mon Nov 29, 2010 5:17 pm    Post subject: Reply with quote

This behaviour could be caused by SQL Server itself if the database has been set with a case insensitive collation.

To look at whether this is the case, see this StackOverflow article:
http://stackoverflow.com/questions/1411161/sql-server-check-case-sensitivity

If it is the case then you will need to change you database to a Case Sensitive collation.
Back to top
View user's profile Send private message
troyhunt



Joined: 28 Nov 2010
Posts: 15
Location: Australia

PostPosted: Wed Dec 01, 2010 11:20 am    Post subject: Reply with quote

After spending more time looking at this issue in depth, having Chris unsure of a resolution and not getting any other feedback from this post or the equivalent one on Stack Overflow - http://stackoverflow.com/questions/4302779/can-red-gate-sql-source-control-identify-a-case-change - I'm calling this one a bug. I'd love to be proven wrong, but that seems to be the case (sorry about the pun!).

So to specifically answer my question, no, it appears SQL Source Control can't natively version a case-only change. However, there is a workaround involving making the change in the working directory and submitting this back via TortoiseSVN (assuming the VCS is SVN). Th full details are now in "Defeating Red Gate’s SQL Source Control insensitivity" - http://www.troyhunt.com/2010/12/defeating-red-gates-sql-source-control.html
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group