Dowloading Work Item Attachments from a SQL Server Jazz database
We are moving away from RTC and I need to export all work Items and attachments from the tool. I was able to export all the work Items from the Tool interface but did not see an option to export attachments. We have now decommissioned the tool and I now have access to the database alone. Can anybody help me with figuring out which tables in the SQl server Jazz database, will get me this data?
Thanks!
Thanks!
One answer
There is as far as I know no automation built in for that.
Please see: https://rsjazz.wordpress.com/2012/09/21/downloading-attachments-from-work-items/
and combine it with: https://rsjazz.wordpress.com/2012/10/29/using-work-item-queris-for-automation/
I don't think you can easily get them from the database, but I am not sure because I always go trough the application to access data.
Please see: https://rsjazz.wordpress.com/2012/09/21/downloading-attachments-from-work-items/
and combine it with: https://rsjazz.wordpress.com/2012/10/29/using-work-item-queris-for-automation/
I don't think you can easily get them from the database, but I am not sure because I always go trough the application to access data.