How can we improve SQL Source Control?

Better implementation of Workitem checkin/tracking

Would it be possible to add under the Commit-comment field a dropdown or list which shows the data of a TFS-"Team Query"?
We have implemented a "CheckIn"-Query which shows the developer his open Tasks/Bugs/... so that he can just select out of this list while checking in the pending changes.
Entering the IDs manually is annoying and most of the developers don't do it because they have to go to the TFS first, catch the ID go back to SQL Server Management Studio and write the text.
In VisualStudio this works fine - the developers just change the tab and select the item(s) and commit the changes on the "pending changes" tab.

I think the most elegant solution would be if you present the possibility to decide if the checkin will be done on TFS directly
or only on the corresponding local TFS-files. If it happens only on the local files you could see them in Visual Studio and use the
functionality there - and more than that you could check in the SQL-Code together with the VisualStudio code at once.
But then you would have to make sure that you don't loose the change-history in order to be able to deploy the changes from Development to Acceptance and Production SQL-Servers.

6 votes
Vote
Sign in
Check!
(thinking…)
Reset
or sign in with
  • facebook
  • google
    Password icon
    I agree to the terms of service
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    DanielDaniel shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

    2 comments

    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      I agree to the terms of service
      Signed in as (Sign out)
      Submitting...
      • StephenStephen commented  ·   ·  Flag as inappropriate

        This is also VERY applicable to the OnTime integration with SVN where at checkin, an additional ticket-search control is added to the standard TortoiseSVN UI.

        We are prevented from adopting OnTime due to the lack of any ability to inform OnTime of a commit or be able to look up ticket numbers via some SSC integration.

      • Thomas HessThomas Hess commented  ·   ·  Flag as inappropriate

        I agree. Please also add check-box to "Ignore check-in policies", instead of having the use #ignorepolicies

      Feedback and Knowledge Base