A SQL Server Management Studio add-in to source control your database in Subversion or Team Foundation Server.
Moderators: Chris Auckland, David Atkinson, sherr, PhilScrace
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.
- Posts: 15
- Joined: Sun Nov 28, 2010 3:36 am
- Location: Australia
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/1411 ... ensitivity
If it is the case then you will need to change you database to a Case Sensitive collation.
- Posts: 330
- Joined: Mon Apr 19, 2010 1:44 pm
- Location: Cambridge, UK
Return to SQL Source Control 1
Who is online
Users browsing this forum: No registered users and 0 guests