Actions in a submenu would be useful
I can right-click on a database (or item within) in Object Explorer and see a choice labelled "SQL Source Control", but all it does is open the tab in the main area. It would be great if it also had a submenu (like TortoiseSVN does in Windows Explorer) which offered "Update", "Commit", "Show log", "Diff", "Revert", "Delete" and so on. Actually it would be great if the latter actions were offered at all (show log, diff, etc.) because to do them now, I need to jump over to Windows Explorer and use Tortoise.
In EA2 (v0.2.1), we added Commit and Get Latest to the Object Explorer right click menu. If you would like other features, please vote/comment on the following (we would need to implement these first before adding them to the right click menu):
Revert/Undo Pending Change – http://redgate.uservoice.com/forums/39019-sql-source-control/suggestions/491513-revert-undo-pending-change
Show Log/History – http://redgate.uservoice.com/forums/39019-sql-source-control/suggestions/471982-tab-for-svn-log-show-history-
Open DB from Source Control – http://redgate.uservoice.com/forums/39019-sql-source-control/suggestions/459952-open-a-database-from-source-control
Diff/Compare with previous version – http://redgate.uservoice.com/forums/39019-sql-source-control/suggestions/491523-diff-or-compare-versions-of-an-object
gregor suttie commented
I agree there should be an action menu so you can quickly see whats changed in a stored procedure with a right click 'View difference' style action
Show Log, Commit, Update, Revert
David P. Murphy commented
We consider three actions essential at all levels: Show Log, Commit, and Update
After that, Revert
After that, Rename
After that, Delete
I'll second everything that davidlaym suggested, which is basically what you get with TortoiseSVN.
Thanks! These are the things we're looking for. Anyone else?
23 votes and no responses to Stephanie ...
based on my experience with source control, I would like to have
at database level:
- Update to latest version
- Check for changes (shows the list of changed objects on wc)
- Show log
- Commit (shows the commit tab)
- Revert (clears the changes done on wc)
- Create new database from source control.
at object level:
- Compare with base (shows script diff between wc and base)
- Revert (clear changes done on wc)
- Commit (shows commit tab for just the selected objects)
- Show log (show log entries witch affect this object)