Skip to content
← Customer Feedback for Redgate

Settings and activity

2 results found

  1. add If not exists to data compare

    225 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    18 comments  ·  SQL Data Compare  ·  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
    Greg L. Wright supported this idea  · 

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

    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…)
    1 comment  ·  SQL Source Control  ·  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
    An error occurred while saving the comment
    Greg L. Wright commented  · 

    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.

    Greg L. Wright shared this idea  ·