Red Gate forums :: View topic - Support for Team Foundation Server Work Items
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Source Control 1
SQL Source Control 1 forum

Support for Team Foundation Server Work Items

Search in SQL Source Control 1 forum
Post new topic   Reply to topic
Jump to:  
Author Message
peter.peart
Site Admin


Joined: 02 Sep 2008
Posts: 362
Location: Top floor, RG towers with the cool kids

PostPosted: Fri Jul 16, 2010 3:01 pm    Post subject: Support for Team Foundation Server Work Items Reply with quote

Since the release of SQL Source Control We have been busy implementing support for Team Foundation Server Work Items. If you do not currently use Work Items a brief description from Microsoft is:

"Team Foundation has work item tracking features designed to assist enterprise software development teams to manage their work and software defect tracking. In Team Foundation, a work item tracks this work, and can be one of the individual tasks required to complete a project, a bug that needs to be fixed, a customer scenario that the project needs to address, or any other piece of work in a project that needs to be tracked in a database. The types of work items available in any given project can be customized by your team to meet your project development requirements using a work item type definition. However, all work items contain the following common elements"

In SQL Source Control (v1.0.3.73+), it is now possible to associate a SQL Source Control 'Commit Change' operation with a TFS work item by typing the following into the 'Comment to add on commit' field on the SQL Source Control 'Commit Changes' tab:

1. To Associate a Commit with a TFS Work item use the following syntax '#A<Work Item number><space><Commit Comment>' e.g. #A106 Associate this change to object Foo to Work Item 106'
2. To Resolve a TFS Work item following a Commit from source control use the following syntax '#R<Work Item number><space><Commit Comment>' e.g. #R106 Resolve Work Item 106 by committing this change to object Foo'

The '#A106' and '#R106' portion of the commit will not appear in the Commit Comment made on the TFS Server; it is simply an instruction to SQL Source Control to associate or resolve the item.

We'd love to hear about your experience with this feature; we'll be working on an enhanced UI to make your SQL Source Control/Work Items experience ingeniously simple and welcome any comments or feedback that you may have.
_________________
Peter Peart
Red Gate Software Ltd
+44 (0)870 160 0037 ext. 8569
1 866 RED GATE ext. 8569
Back to top
View user's profile Send private message Send e-mail
sherr



Joined: 19 Mar 2009
Posts: 125
Location: Cambridge

PostPosted: Wed Aug 18, 2010 11:07 pm    Post subject: Early Access Release to Associate Commits to TFS Work Items Reply with quote

The Early Access Release to associate your commits with work items is available at http://www.red-gate.com/MessageBoard/viewtopic.php?t=11654.
_________________
Thank you!
Stephanie M. Herr Smile
Delivery Product Manager
Back to top
View user's profile Send private message
JeffJ



Joined: 17 Mar 2008
Posts: 5

PostPosted: Mon Aug 23, 2010 10:00 pm    Post subject: TFS Tags Reply with quote

Would it be possible to add tags for other standard states such as "Closed" as well?
Back to top
View user's profile Send private message
AdamR



Joined: 07 Apr 2010
Posts: 13

PostPosted: Mon Aug 23, 2010 11:50 pm    Post subject: Reply with quote

Is it possible to get a UI for this so we can search for WIs or by user, etc...
Back to top
View user's profile Send private message
Chris Auckland



Joined: 24 Oct 2006
Posts: 757
Location: Red Gate Software Ltd.

PostPosted: Mon Aug 30, 2010 1:19 pm    Post subject: Reply with quote

Quote:
Would it be possible to add tags for other standard states such as "Closed" as well?


Hi JeffJ,

I've added a feature request for this: SOC-1513
_________________
Chris
Back to top
View user's profile Send private message Send e-mail
Chris Auckland



Joined: 24 Oct 2006
Posts: 757
Location: Red Gate Software Ltd.

PostPosted: Mon Aug 30, 2010 1:29 pm    Post subject: Reply with quote

Quote:
Is it possible to get a UI for this so we can search for WIs or by user, etc...


Hi AdamR,

Can you go into a little bit more detail with regards to the kind of UI you would like? Is there any functionality that you're looking for that Team Explorer doesn't provide, or are you looking for a more convenient interface than using Team Explorer?
_________________
Chris
Back to top
View user's profile Send private message Send e-mail
AdamY



Joined: 15 Oct 2010
Posts: 41

PostPosted: Fri Oct 15, 2010 8:47 pm    Post subject: 100% agree - but more than just work item. Reply with quote

An easy way (UI) to associate the check-in with a work item is a must for us (we have not bought yet, just evaluating). The #A1234 hack helps, but is easy to forget and doesn't cover everything. TFS can be set up to require certain things like a work item, code reviewer, and other "Check-In Notes". SQL Source Control ignores all those requirements now which in turn generates "Policy Failure" alerts to our tech leads. We really need the tool to support this. A simple search or list would be nice.

FYI - the workspace issue (not getting to pick a workspace or its location) is the other big deal breaker for us (probably more so than the work item issue). Shelving would be nice, too. Other than that, we love it so far.
Back to top
View user's profile Send private message
vsalard



Joined: 29 Mar 2011
Posts: 1

PostPosted: Tue Mar 29, 2011 1:11 pm    Post subject: Re: Support for Team Foundation Server Work Items Reply with quote

peter.peart wrote:
Since the release of SQL Source Control We have been busy implementing support for Team Foundation Server Work Items. [...]; we'll be working on an enhanced UI to make your SQL Source Control/Work Items experience ingeniously simple and welcome any comments or feedback that you may have.


Hi Peter,

Would you have any news (or date) to reveal concerning this TFS improved integration ? (I mean something more evoluated than a parse trick)

Thx in advance,

Rgds,

Vincent.
Back to top
View user's profile Send private message
Jack_TeamGB



Joined: 17 Aug 2012
Posts: 2
Location: Great Britain

PostPosted: Fri Aug 17, 2012 9:46 am    Post subject: Reply with quote

Common Peter, an update please.

I bought this product for my team with the promise that this was in the pipeline and near delivery. Any chance of a Work Item GUI interface soon?

Many thanks
Back to top
View user's profile Send private message
David Atkinson



Joined: 05 Dec 2005
Posts: 1124
Location: Twitter: @dtabase

PostPosted: Tue Aug 21, 2012 12:09 am    Post subject: Reply with quote

We hope to add this feature in SQL Source Control v4. The downside is that this is unlikely to be released before 2013 due to resourcing constraints.

Our sincere apologies,

David Atkinson
Product Manager
Red Gate
Back to top
View user's profile Send private message Send e-mail
Jack_TeamGB



Joined: 17 Aug 2012
Posts: 2
Location: Great Britain

PostPosted: Wed Aug 22, 2012 9:16 am    Post subject: Reply with quote

Hi David,

That's painful for us particularly as this promised feature was key to my decision to move my team to RedGate tools.

I appreciate you're honest reply and thanks for responding quickly.

Thanks
Back to top
View user's profile Send private message
David Atkinson



Joined: 05 Dec 2005
Posts: 1124
Location: Twitter: @dtabase

PostPosted: Wed Aug 22, 2012 9:20 am    Post subject: Reply with quote

We honestly would have expected to have put in this feature by now, but various circumstances have conspired against us.

The v4 release will be focused on improving the team collaboration experience, and I'm hoping it will not only be about browsing work items, but also exposing these in relevant parts of the UI so it will be easier for all to see the intent behind a particular historical change to your database.
Back to top
View user's profile Send private message Send e-mail
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group