{"id":4093,"date":"2006-03-18T15:35:00","date_gmt":"2006-03-18T15:35:00","guid":{"rendered":"https:\/\/blogs.msdn.microsoft.com\/buckh\/2006\/03\/18\/manually-modifying-tfs-databases-is-a-bad-idea\/"},"modified":"2006-03-18T15:35:00","modified_gmt":"2006-03-18T15:35:00","slug":"manually-modifying-tfs-databases-is-a-bad-idea","status":"publish","type":"post","link":"https:\/\/devblogs.microsoft.com\/buckh\/manually-modifying-tfs-databases-is-a-bad-idea\/","title":{"rendered":"Manually modifying TFS databases is a bad idea"},"content":{"rendered":"<p>Over the last several months, I&#8217;ve seen folks post SQL hacks to modify TFS databases, usually to try to work around some limitation such as <a href=\"\/buckh\/archive\/2006\/02\/24\/delete_work_item_type.aspx\">not being able to delete work item types<\/a>.&nbsp; Marcel de Vries, a Microsoft MVP who has been using TFS for quite a while, recently wrote a post on his experience in trying to do this.&nbsp; As he mentions, there are many relationships and dependencies that are not obvious, and sometimes you won&#8217;t find the problems until much later.<\/p>\n<blockquote>\n<p><a href=\"http:\/\/blogs.infosupport.com\/marcelv\/archive\/2006\/03\/16\/4483.aspx\">Don&rsquo;t change a TFS database by hand; How I got myself in real trouble<\/a><\/p>\n<\/blockquote>\n","protected":false},"excerpt":{"rendered":"<p>Over the last several months, I&#8217;ve seen folks post SQL hacks to modify TFS databases, usually to try to work around some limitation such as not being able to delete work item types.&nbsp; Marcel de Vries, a Microsoft MVP who has been using TFS for quite a while, recently wrote a post on his experience [&hellip;]<\/p>\n","protected":false},"author":94,"featured_media":10268,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[1],"tags":[6,8],"class_list":["post-4093","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-uncategorized","tag-source-control","tag-team-foundation"],"acf":[],"blog_post_summary":"<p>Over the last several months, I&#8217;ve seen folks post SQL hacks to modify TFS databases, usually to try to work around some limitation such as not being able to delete work item types.&nbsp; Marcel de Vries, a Microsoft MVP who has been using TFS for quite a while, recently wrote a post on his experience [&hellip;]<\/p>\n","_links":{"self":[{"href":"https:\/\/devblogs.microsoft.com\/buckh\/wp-json\/wp\/v2\/posts\/4093","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/devblogs.microsoft.com\/buckh\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/devblogs.microsoft.com\/buckh\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/buckh\/wp-json\/wp\/v2\/users\/94"}],"replies":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/buckh\/wp-json\/wp\/v2\/comments?post=4093"}],"version-history":[{"count":0,"href":"https:\/\/devblogs.microsoft.com\/buckh\/wp-json\/wp\/v2\/posts\/4093\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/buckh\/wp-json\/wp\/v2\/media\/10268"}],"wp:attachment":[{"href":"https:\/\/devblogs.microsoft.com\/buckh\/wp-json\/wp\/v2\/media?parent=4093"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/buckh\/wp-json\/wp\/v2\/categories?post=4093"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/buckh\/wp-json\/wp\/v2\/tags?post=4093"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}