{"id":616,"date":"2010-01-12T16:40:00","date_gmt":"2010-01-12T16:40:00","guid":{"rendered":"\/blogs\/bobb\/post\/DACPAC-and-pre-SQL-Server-2008-R2-versions.aspx"},"modified":"2014-01-20T12:18:19","modified_gmt":"2014-01-20T20:18:19","slug":"dacpac-and-pre-sql-server-2008-r2-versions","status":"publish","type":"post","link":"https:\/\/www.sqlskills.com\/blogs\/bobb\/dacpac-and-pre-sql-server-2008-r2-versions\/","title":{"rendered":"DACPAC and pre-SQL Server 2008 R2 versions"},"content":{"rendered":"<p>\nI thought it was curious that in a DACPAC&nbsp;you can specify required version and edition of SQL Server as a deployment option. But DAC (Data-Tier Applications) is a new feature of SQL Server 2008 R2 and VS2010 data tools. So what versions and editions does it support? (or will it support?). The somewhat surprising answer came in today, as an answer to a forum question.\n<\/p>\n<p>\nCheck <a href=\"http:\/\/social.msdn.microsoft.com\/Forums\/en-US\/sqlkjmanageability\/thread\/fb2a68dd-fe1a-47a8-9a39-042cef826c93\">this thread<\/a> out&#8230; If I&#39;m reading this correctly, and &quot;No &lt;sup&gt;1&lt;\/sup&gt;&quot; means &quot;No with a superscript of 1&quot;, the functionality may be being backported (see note 1 below the chart).&nbsp;Very cool!\n<\/p>\n<p>\nVisual Studio 2010 B2 can make DACs and deploy them as of Nov 2008 CTP of R2.&nbsp;Take a look at <a href=\"http:\/\/blogs.msdn.com\/b\/dtjones\/archive\/2009\/10\/27\/developing-data-tier-applications-using-visual-studio-2010.aspx\" class=\"broken_link\">Sanjay&#39;s video<\/a>&nbsp;if you missed this announcement.\n<\/p>\n<p>\nNote that DAC is a separate concept from SQL Server Utility, although Utility will keep per-DAC stats (one&nbsp;diagram&nbsp;in BOL insinuates non-DAC databases too, but I think I might&nbsp;be misreading the diagram)&nbsp;on the SQL Servers it manages. Utility can only manage 2008 R2 instances at present but maybe (<a href=\"http:\/\/social.msdn.microsoft.com\/Forums\/en-US\/sqlkjappmsmgmt\/thread\/f68e1252-b1f2-41e3-b90d-ce12edaff221\">big maybe<\/a>, move along, nothing to see here) they might backport the support to 2008 some day. And <a href=\"http:\/\/msdn.microsoft.com\/en-us\/library\/ee210579(SQL.105).aspx\">remember<\/a>, the SQL Server edition for a UCP (Utility Control Point)&nbsp;must be SQL Server 2008 R2 Data Center, Developer, or Enterprise Evaluation. That&#39;s Data Center-only for &quot;real&quot; installations.\n<\/p>\n<p>\nGlad to see this functionality taking shape.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>I thought it was curious that in a DACPAC&nbsp;you can specify required version and edition of SQL Server as a deployment option. But DAC (Data-Tier Applications) is a new feature of SQL Server 2008 R2 and VS2010 data tools. So what versions and editions does it support? (or will it support?). The somewhat surprising answer [&hellip;]<\/p>\n","protected":false},"author":7,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[13,30],"tags":[],"class_list":["post-616","post","type-post","status-publish","format-standard","hentry","category-data-tier-applications-dac","category-sql-server-2008-r2"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v21.9.1 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>DACPAC and pre-SQL Server 2008 R2 versions - Bob Beauchemin<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.sqlskills.com\/blogs\/bobb\/dacpac-and-pre-sql-server-2008-r2-versions\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"DACPAC and pre-SQL Server 2008 R2 versions - Bob Beauchemin\" \/>\n<meta property=\"og:description\" content=\"I thought it was curious that in a DACPAC&nbsp;you can specify required version and edition of SQL Server as a deployment option. But DAC (Data-Tier Applications) is a new feature of SQL Server 2008 R2 and VS2010 data tools. So what versions and editions does it support? (or will it support?). The somewhat surprising answer [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.sqlskills.com\/blogs\/bobb\/dacpac-and-pre-sql-server-2008-r2-versions\/\" \/>\n<meta property=\"og:site_name\" content=\"Bob Beauchemin\" \/>\n<meta property=\"article:published_time\" content=\"2010-01-12T16:40:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2014-01-20T20:18:19+00:00\" \/>\n<meta name=\"author\" content=\"Bob Beauchemin\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Bob Beauchemin\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/bobb\/dacpac-and-pre-sql-server-2008-r2-versions\/\",\"url\":\"https:\/\/www.sqlskills.com\/blogs\/bobb\/dacpac-and-pre-sql-server-2008-r2-versions\/\",\"name\":\"DACPAC and pre-SQL Server 2008 R2 versions - Bob Beauchemin\",\"isPartOf\":{\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/bobb\/#website\"},\"datePublished\":\"2010-01-12T16:40:00+00:00\",\"dateModified\":\"2014-01-20T20:18:19+00:00\",\"author\":{\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/bobb\/#\/schema\/person\/62bfa986c5b5d28fcffd8b4fc409c73e\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/bobb\/dacpac-and-pre-sql-server-2008-r2-versions\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.sqlskills.com\/blogs\/bobb\/dacpac-and-pre-sql-server-2008-r2-versions\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/bobb\/dacpac-and-pre-sql-server-2008-r2-versions\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.sqlskills.com\/blogs\/bobb\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Data-Tier Applications (DAC)\",\"item\":\"https:\/\/www.sqlskills.com\/blogs\/bobb\/category\/data-tier-applications-dac\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"DACPAC and pre-SQL Server 2008 R2 versions\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/bobb\/#website\",\"url\":\"https:\/\/www.sqlskills.com\/blogs\/bobb\/\",\"name\":\"Bob Beauchemin\",\"description\":\"SQL Server Blog\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.sqlskills.com\/blogs\/bobb\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/bobb\/#\/schema\/person\/62bfa986c5b5d28fcffd8b4fc409c73e\",\"name\":\"Bob Beauchemin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/bobb\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/6f80e6cc667410857fa6a21931dc528b8092f4d112bf7a8ff7c267674d44ee37?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/6f80e6cc667410857fa6a21931dc528b8092f4d112bf7a8ff7c267674d44ee37?s=96&d=mm&r=g\",\"caption\":\"Bob Beauchemin\"},\"sameAs\":[\"http:\/www.sqlskills.com\/blogs\/bobb\/\"],\"url\":\"https:\/\/www.sqlskills.com\/blogs\/bobb\/author\/bobb\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"DACPAC and pre-SQL Server 2008 R2 versions - Bob Beauchemin","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.sqlskills.com\/blogs\/bobb\/dacpac-and-pre-sql-server-2008-r2-versions\/","og_locale":"en_US","og_type":"article","og_title":"DACPAC and pre-SQL Server 2008 R2 versions - Bob Beauchemin","og_description":"I thought it was curious that in a DACPAC&nbsp;you can specify required version and edition of SQL Server as a deployment option. But DAC (Data-Tier Applications) is a new feature of SQL Server 2008 R2 and VS2010 data tools. So what versions and editions does it support? (or will it support?). The somewhat surprising answer [&hellip;]","og_url":"https:\/\/www.sqlskills.com\/blogs\/bobb\/dacpac-and-pre-sql-server-2008-r2-versions\/","og_site_name":"Bob Beauchemin","article_published_time":"2010-01-12T16:40:00+00:00","article_modified_time":"2014-01-20T20:18:19+00:00","author":"Bob Beauchemin","twitter_misc":{"Written by":"Bob Beauchemin","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.sqlskills.com\/blogs\/bobb\/dacpac-and-pre-sql-server-2008-r2-versions\/","url":"https:\/\/www.sqlskills.com\/blogs\/bobb\/dacpac-and-pre-sql-server-2008-r2-versions\/","name":"DACPAC and pre-SQL Server 2008 R2 versions - Bob Beauchemin","isPartOf":{"@id":"https:\/\/www.sqlskills.com\/blogs\/bobb\/#website"},"datePublished":"2010-01-12T16:40:00+00:00","dateModified":"2014-01-20T20:18:19+00:00","author":{"@id":"https:\/\/www.sqlskills.com\/blogs\/bobb\/#\/schema\/person\/62bfa986c5b5d28fcffd8b4fc409c73e"},"breadcrumb":{"@id":"https:\/\/www.sqlskills.com\/blogs\/bobb\/dacpac-and-pre-sql-server-2008-r2-versions\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.sqlskills.com\/blogs\/bobb\/dacpac-and-pre-sql-server-2008-r2-versions\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.sqlskills.com\/blogs\/bobb\/dacpac-and-pre-sql-server-2008-r2-versions\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.sqlskills.com\/blogs\/bobb\/"},{"@type":"ListItem","position":2,"name":"Data-Tier Applications (DAC)","item":"https:\/\/www.sqlskills.com\/blogs\/bobb\/category\/data-tier-applications-dac\/"},{"@type":"ListItem","position":3,"name":"DACPAC and pre-SQL Server 2008 R2 versions"}]},{"@type":"WebSite","@id":"https:\/\/www.sqlskills.com\/blogs\/bobb\/#website","url":"https:\/\/www.sqlskills.com\/blogs\/bobb\/","name":"Bob Beauchemin","description":"SQL Server Blog","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.sqlskills.com\/blogs\/bobb\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.sqlskills.com\/blogs\/bobb\/#\/schema\/person\/62bfa986c5b5d28fcffd8b4fc409c73e","name":"Bob Beauchemin","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.sqlskills.com\/blogs\/bobb\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/6f80e6cc667410857fa6a21931dc528b8092f4d112bf7a8ff7c267674d44ee37?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/6f80e6cc667410857fa6a21931dc528b8092f4d112bf7a8ff7c267674d44ee37?s=96&d=mm&r=g","caption":"Bob Beauchemin"},"sameAs":["http:\/www.sqlskills.com\/blogs\/bobb\/"],"url":"https:\/\/www.sqlskills.com\/blogs\/bobb\/author\/bobb\/"}]}},"_links":{"self":[{"href":"https:\/\/www.sqlskills.com\/blogs\/bobb\/wp-json\/wp\/v2\/posts\/616","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.sqlskills.com\/blogs\/bobb\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.sqlskills.com\/blogs\/bobb\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/bobb\/wp-json\/wp\/v2\/users\/7"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/bobb\/wp-json\/wp\/v2\/comments?post=616"}],"version-history":[{"count":0,"href":"https:\/\/www.sqlskills.com\/blogs\/bobb\/wp-json\/wp\/v2\/posts\/616\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.sqlskills.com\/blogs\/bobb\/wp-json\/wp\/v2\/media?parent=616"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/bobb\/wp-json\/wp\/v2\/categories?post=616"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/bobb\/wp-json\/wp\/v2\/tags?post=616"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}