Skip to content
← SQL Compare

How can we improve SQL Compare?

SQL Compare

Categories

JUMP TO ANOTHER FORUM

(thinking…)

Display Last Modified

I've asked for this many times since SQL Compare 7.

Please allow us to see the Last Modified Date on the objects. The information is VERY easily obtained.

select objectid, Modifydate from sys.objects where type='P'

It would be very useful and beneficial to see.

105 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…)
Rick shared this idea  ·   ·  Report…  ·  Admin →
completed  ·  Andrew Farries responded  · 

We have just released an update to SQL Compare V12 on the Frequent Updates channel containing this feature. For tables, views, functions and stored procedures the comparison grid will show an extra column indicating when the object’s schema last changed.

Feedback on this is best posted on the forums:

https://forums.red-gate.com/viewtopic.php?f=200&t=80289

We are interested in hearing whether this solves your problems and about any further improvements we can make.

Show previous admin responses (2)

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
  • AdminAndrew Farries (Admin, Redgate) commented  ·   ·  Report

    We have just released an update to SQL Compare V12 on the Frequent Updates channel containing this feature. For tables, views, functions and stored procedures the comparison grid will show an extra column indicating when the object's schema last changed.

    Feedback on this is best posted on the forums:

    https://forums.red-gate.com/viewtopic.php?f=200&t=80289

    We are interested in hearing whether this solves your problems and about any further improvements we can make.

  • Mickey Stuewe commented  ·   ·  Report

    This would be very helpful when you find a SQL Object you didn't expect to be modified and the user didn't add any comments on when they modified it, so it would help with troubleshooting.

  • Anthony commented  ·   ·  Report

    As an option on both source and target would be great.
    It should be another sortable column just like Type, Owner, Object Name.

  • Anonymous commented  ·   ·  Report

    Both would be awesome but if not then the source at least.

  • Anonymous commented  ·   ·  Report

    Or even a filter by last modified date for sp's, views and functions.

  • Anonymous commented  ·   ·  Report

    Yes, please! I will love you long time!

  • Anonymous commented  ·   ·  Report

    Very important... Please include Last Modified Date

  • Anonymous commented  ·   ·  Report

    I agree, this would be very helpful to see last modified date.

  • Len Kalman commented  ·   ·  Report

    I would like this built into SQL Compare as well. Very usefull

  • Anonymous commented  ·   ·  Report

    You can easily see that in SSMS in view Objects. Right click on the header and pick Modify Date