Associate task for database repository in GitHub

dileep

Can we associate TFS or Jira task when committing changes for database using GitHub as repository

Eddie D

Hi, Thank you for your forum post:

Does this answer your question?

To associate a check-in with a TFS work item, include #A[work item number] in the check-in comment. For example: #A106.

Many Thanks
Eddie

dileep

Hey Eddie, thanks for the response
#A[work item number] works only if TFS is used as repository. Is there any way if GitHub is used as database repository?

TheGT

I'd like to know if RedGate SQL SourceControl supports associating work items in VSTS through GIT as well.

Sergio R

Hi,

No, associating work items in VSTS through GIT as well is not supported.

Kind Regards,

Sergio R

You could try the option to "Automatically create links for work items mentioned in a commit comment" for the repo (see https://docs.microsoft.com/en-us/vsts/git/concepts/repository-settings?view=vsts). Then, referencing the work item with #id in the commit message should link automatically. However this is something external to SQL Source Control and we haven't tested it ourselves.

TheGT

Looks like you can type in #<work item id> in the SSMS commit screen's comment field and it will link up as expected.