Problem:
We had a requirement to update the TFS database. Scenario is that we have one custom field in the Task work item, which is defined as string. For getting a proper report, we need to change the data type of the custom field to double. Team deployed the SQL script, which will change the custom field type from string to double. Moreover, the script mark the field as reportable. This change in turn affected the TFS warehouse and analysis databases and the report generation stopped.
Solution:
Whenever there is a TFS database change, which mark the field as reportable, follow the steps to properly deploy the same into production.
1. Prepare the SQL Script to do the TFS database change
2. Regenerate both warehouse and analysis databases using TFS Admin Console
3. Queue the warehouse and analysis process
Regeneration of TFS warehouse and analysis databases ensure the proper schema update from the modified TFS database.