Skip to content
← SQL Source Control

How can we improve SQL Source Control?

SQL Source Control: Initial Setup

Categories

JUMP TO ANOTHER FORUM

(thinking…)

add option to view commited deleted object code from repsostiry in SSMS

Currently there is not easy way to see or restore a deleted object that was committed. The object code is still in Source Control - but no easy way to see or restore it using SSMS.

10 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…)
Lisa Quinn 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
Kendra responded  · 

I believe that this is achievable by viewing object history in SQL Source Control and then launching SQL Compare or SQL Data Compare to do a diff and potentially restore the prior version. More info is here: https://documentation.red-gate.com/soc7/common-tasks/update-to-a-revision-from-source-control

This does require having licenses for SQL Compare and SQL Data Compare, however, and your suggestion is specific to doing this with SSMS, so I am not marking this as complete.

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
  • Horst commented  ·   ·  Report

    Implement a seach function will be very helpfull to find those deleted/dropped objects. Search the history by hand is not very efficient.

  • Michael Murphy-McCarthy commented  ·   ·  Report

    Kendra, that only works if you can find it. Finding a deleted/dropped object requires manually going through the history. There is no way to search for a deleted object.