I know this is an old post of mine but I wanted to see if this was a possible future feature?
We don't migrate database stored procedure changes from Dev, Test, Prod. Because of our environment we may make a change directly to a production procedure and then check-in that change using SQL Source control. This would just eliminate the second step. So basically, ON ALTER, COMMIT TO TFS.
Tips and how-to guides for Redgate products
Ask, discuss, and solve questions about Redgate's tools
Meet us at an event, get sponsored, and join our Friends of Redgate
In-depth articles and opinion from Redgate's technical journal
Get the latest news and training with the monthly Redgate Update