Impact of TFS Database Updates


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.


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.

About ambilykk

I am a Technology Evangelist on Microsoft Technologies. I am carrying the passion on Microsoft technologies specifically on web technologies such as ASP .Net and Ajax. My interests also include Azure and Visual Studio. Technology adoption and learning is my key strength and technology sharing is my passion.
This entry was posted in TFS and tagged . Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s