Formatting changes not recognized
jed.sutton
Posts: 2
My project has instituted new SQL Style Guidelines. We use SQL Prompt to format the code per the process. Our process going forward when modifying DB objects is:
Does anyone have any ideas?
- Open DB object
- Reformat the object using SQL Prompt
- Commit to SVN using SQL Source Control to capture baseline for new format
- Make modifications
- Commit to SVN using SQL Source Control
Does anyone have any ideas?
Comments
If the only differences are whitespace and/or casing, then SQL Source Control most likely won't pick this up. We only detect casing differences if the SQL Server is set to be case sensitive. Unfortunately there's no way to override this behaviour (but do please vote for the suggestion on our Uservoice page for SQL Source Control.
If you make some kind of syntactic change then we should pick up the difference; and I believe the fresh commit should then use the new formatting.
Redgate Software
This is the SQL Server default. You can check it by:
SELECT name, collation_name
FROM sys.databases
WHERE name = 'mydatabase'
It would be nice if there were a workaround. We recently had an effort where we changed the strings on our client's site to be mixed case (they are stored in the db). We have spent a number of days trying to deal with the inability to actually cause changes to be rolled out to other machines via SSC.
The funny thing is that in the script files in subversion, the casing is correct. That is, I can change the case locally and also another field like a datestamp and SSC will take the commit. However when another developer gets latest, it gives them the updated date but not the updated string.
There must be a fix for this ... it's also confusing because the comparison pane on the commit changes screen shows the strings as different (i.e. it's showing a case sensitive comparison).
Is it a bug perhaps?