Skip to content
← SQL Source Control

How can we improve SQL Source Control?

SQL Source Control

Categories

JUMP TO ANOTHER FORUM

(thinking…)

Default constraint names with escape characters aren't registered as a change

I accidently did an sprename 'DFVisitsSome3234234', '[DFVisits_SomeNumber]', 'Object' and committed it to SVN. Now, when I change it back, the Source Control does not detect this as a change to commit back. How do I get around this, or it's a bug.

1 vote
Vote

We're glad you're here

Please sign in to leave feedback
Signed in as (Sign out)
Close
Close
You have left! (?) (thinking…)
Greg L. Wright shared this idea  ·   ·  Report…  ·  Admin →
How important is this to you?

We're glad you're here

Please sign in to leave feedback
Signed in as (Sign out)
Close
Close

We're glad you're here

Please sign in to leave feedback
Signed in as (Sign out)
Close
Close
Submitting...
An error occurred while saving the comment
  • Greg L. Wright commented  ·   ·  Report

    Correction, "when I changed it back" from "[DF_Visits_SomeNumber]" "DF_Visits_SomeNumber" so that the brackets "[]" didn't appear in the Tables | Constraints list, the change to re move the brackets was recognized as a change. Thus no commit back to the database could occur. I had to revert back from the history revision using SQL Compare, and then do the sp_rename correctly without the mistaken "[]" brackets. This was a bulk operation to change all Auto Named Default Constraints to my own standard of named Default Constraint of "DF_TableName_ColumnName".

    So, I performed a work around, but it was a long way around for not seeing the change of simply a bracket in the name.