Skip to content
← SQL Source Control

How can we improve SQL Source Control?

SQL Source Control: History/Log

Categories

JUMP TO ANOTHER FORUM

(thinking…)

object level history

I would like to see history by object. For eg, we should be able to see history for Customer table or Customer.GetOrder sp.

15 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…)
Sriram Garimella shared this idea  ·   ·  Report…  ·  Admin →

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

    Stephanie - Your idea would be helpful, but definitely not high priority (in my opinion). There are other issues that are much more important and I've left comments about those on this site and the Red Gate forum. Thanks again for clarifying the feature for me.

  • AdminRedgate Administrator (Admin, Redgate) commented  ·   ·  Report

    Hi Adam,

    We've heard from someone else that this is kind of confusing... Would it help if we grayed out the other objects that were in the changeset, but not the object you're interested in?

  • Adam commented  ·   ·  Report

    Thank you, Stephanie. I use TFS. View history - in my opinion - should show you the history for an object, not the entire changeset. If I want to see the history of just a table, I can still do it within TFS (Visual Studio), but it would be nicer to see it in SSMS (SQL Source Control). As it is now, it is not useful for me. I rarely need to see all the changes in a changeset and can do so in Visual Studio if needed.

  • AdminRedgate Administrator (Admin, Redgate) commented  ·   ·  Report

    Hi Adam,

    Are you using SVN or TFS?

    In v1.1.0.19, you should only see history items in the top list that contain the table you are interested in. In the middle area, you will still see all objects that were committed in the same changeset as the table. This allows you to see all changes in the changeset because the table change could be part of something bigger.

    In SVN, only the table is in black and the other objects are grayed out. This is similar to what TSVN does. In TFS, everything is black, which is what TFS' source control explorer does.

    If you have any problems, please contact support@red-gate.com.

  • Adam commented  ·   ·  Report

    I have version 1.1.0.19 and it does not work. I right-click on a table (via Object Explorer) to view history and it shows me the entire database history.