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 (v18.104.22.168+), 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.
Red Gate Software Ltd
+44 (0)870 160 0037 ext. 8569
1 866 RED GATE ext. 8569