Skip to content
← Customer Feedback for Redgate

Settings and activity

1 result found

  1. Undo data changes

    200 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…)
    8 comments  ·  SQL Source Control » Static Data  ·  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
    Kendra responded

    While SQL Source Control does not currently provide a simple way to right click and ‘Undo’ static data changes on the ‘Commit’ screen as suggested, there is a workaround which may help some users.

    If you wish to revert the static data in the table to a previous version which you have committed, you can do this by viewing the history of commits for the object in SQL Source Control, and then launching SQL Data Compare to update the database.

    Please note that this workaround requires a license for Data Compare. More detail on how to do this are here: https://documentation.red-gate.com/soc/common-tasks/update-to-a-revision-from-source-control

    An error occurred while saving the comment
    DanCaveman commented  · 

    This is a very expensive tool. The whole purpose is to use the database like you do source code. Not being able to undo is crucial. It wastes so much time to have to unlink and re-link. Even just refreshing the Get Latest or Commit takes a long time.

    If it can do it properly when I link the database to source control, why can't it update my data properly on command?