{"id":813,"date":"2011-01-31T05:00:00","date_gmt":"2011-01-31T05:00:00","guid":{"rendered":"https:\/\/blogs.msdn.microsoft.com\/buckh\/2011\/01\/31\/can-you-downgrade-from-sql-enterprise-to-sql-standard\/"},"modified":"2011-01-31T05:00:00","modified_gmt":"2011-01-31T05:00:00","slug":"can-you-downgrade-from-sql-enterprise-to-sql-standard","status":"publish","type":"post","link":"https:\/\/devblogs.microsoft.com\/buckh\/can-you-downgrade-from-sql-enterprise-to-sql-standard\/","title":{"rendered":"Can you downgrade from SQL Enterprise to SQL Standard?"},"content":{"rendered":"<p><strong>Question<\/strong>: Can a TFS 2010 Team Project Collection (TPC) on SQL Server 2008 Enterprise be down converted to SQL Server <b>Standard<\/b> 2008 edition?<\/p>\n<p><strong>Answer<\/strong>: This is covered in the <a href=\"http:\/\/blogs.msdn.com\/b\/bkrieger\/archive\/2010\/03\/31\/team-foundation-server-2010-upgrade-guide-from-beta2-or-rc-to-rtm-release.aspx\">2010 Upgrade guide<\/a> post.<\/p>\n<p>The script is: exec prc_EnablePrefixCompression @online = 0, @disable = 1<\/p>\n<p>(answer provided by Ed Holloway)<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Question: Can a TFS 2010 Team Project Collection (TPC) on SQL Server 2008 Enterprise be down converted to SQL Server Standard 2008 edition? Answer: This is covered in the 2010 Upgrade guide post. The script is: exec prc_EnablePrefixCompression @online = 0, @disable = 1 (answer provided by Ed Holloway)<\/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":[8,11],"class_list":["post-813","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-uncategorized","tag-team-foundation","tag-tfs-2010"],"acf":[],"blog_post_summary":"<p>Question: Can a TFS 2010 Team Project Collection (TPC) on SQL Server 2008 Enterprise be down converted to SQL Server Standard 2008 edition? Answer: This is covered in the 2010 Upgrade guide post. The script is: exec prc_EnablePrefixCompression @online = 0, @disable = 1 (answer provided by Ed Holloway)<\/p>\n","_links":{"self":[{"href":"https:\/\/devblogs.microsoft.com\/buckh\/wp-json\/wp\/v2\/posts\/813","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=813"}],"version-history":[{"count":0,"href":"https:\/\/devblogs.microsoft.com\/buckh\/wp-json\/wp\/v2\/posts\/813\/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=813"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/buckh\/wp-json\/wp\/v2\/categories?post=813"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/buckh\/wp-json\/wp\/v2\/tags?post=813"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}