{"id":493,"date":"2012-04-17T15:00:00","date_gmt":"2012-04-17T15:00:00","guid":{"rendered":"\/blogs\/bobb\/post\/The-Rest-of-the-Story-Co-existing-VS2010-and-SSDT-database-projects.aspx"},"modified":"2014-01-20T12:21:47","modified_gmt":"2014-01-20T20:21:47","slug":"the-rest-of-the-story-co-existing-vs2010-and-ssdt-database-projects","status":"publish","type":"post","link":"https:\/\/www.sqlskills.com\/blogs\/bobb\/the-rest-of-the-story-co-existing-vs2010-and-ssdt-database-projects\/","title":{"rendered":"The Rest of the Story: Co-existing VS2010 and SSDT database projects"},"content":{"rendered":"

\nAfter my last adventure, I thought it would be interesting to try the "upgrade path" with SSDT and older "Database Projects" (i.e. Visual Studio for Database Professionals, or whatever the last name was before we went to the nice SSDT acronym, I always called them "Data Dude" projects after Gert Drapers<\/a>, the original Data Dude).\n<\/p>\n

\nNote first-off that when you have both VS2010 and SSDT projects installed into Visual Studio, there are two main menus, one called "SQL" and the other called "Data". In case you can't guess, "Data" is the one that goes with the "older" projects (it contains an entry for "Data Compare", a feature that SSDT doesn't have yet). And "SQL" is the SSDT project menu. There's a few "dualing toolbars" too; luckily for me, I'm not a big toolbar user in VS.\n<\/p>\n

\nAt least in VS2010 the Database Projects were always version-specific in name so I know that I can't target SQL Server 2012 in a "SQL Server 2005 or 2008 database project". Easy. Opening one of these projects brings up a "Convert to SSDT" dialog. This works as advertised, just
\nrealize that there are some "artifacts" that are not converted because the corresponding
\nfeature doesn't exist in SSDT yet (e.g. Data Generation Plans). Backing up the old project is
\na good idea in any case. See this page<\/a> for a list.\n<\/p>\n

\nFinally, there are Data Tier Application projects. These support SQL Azure and the subset of
\ndatabase objects that SQL Azure supports. You can create a DAC Project in Visual Studio after
\nthe SSDT tools are installed. Interestingly (but expected), you can't import database objects
\nfrom a SQL Server 2012 database, even if the database only contains the subset of objects
\nthat DAC supported in DAC V2.0, you're presented with an "Unable to connect to database"
\nmessage. Surprisingly, if you set your SQL Server 2012 database to Version 90 or 100
\ncompatibility mode (thats SQL2005 or SQL2008 compatibility), creating a DAC project and importing the
\ndatabase now works! (if it contains the right subset of objects). And of course the project
\ntype would work (at least at this point in time) with a SQL Azure database or importing a
\nV2.0 (but not V3.0) DACPAC.
\nBringing up an existing VS DAC project brings the (at this point) familiar "Convert" dialog.
\nBear in mind that DAC projects could have some of the same unsupported artifacts as Database
\nProjects. \n<\/p>\n

\nGot it? So now you can co-exist with both\/all sets of SQL database projects, database-version
\nwilling. There are some nice new features in SSDT that make it compelling to convert, and the
\n"catch up" features may be added soon, because SSDT will be updated "on a SQL Azure cadance".
\nThat's once every 3-6 months. And, come Visual Studio 11 (available in CTP\/beta now), there
\nwill ONLY be SSDT projects. So…Enjoy!\n<\/p>\n

\n@bobbeauch<\/p>\n","protected":false},"excerpt":{"rendered":"

After my last adventure, I thought it would be interesting to try the "upgrade path" with SSDT and older "Database Projects" (i.e. Visual Studio for Database Professionals, or whatever the last name was before we went to the nice SSDT acronym, I always called them "Data Dude" projects after Gert Drapers, the original Data Dude). […]<\/p>\n","protected":false},"author":7,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[13,31,33],"tags":[],"class_list":["post-493","post","type-post","status-publish","format-standard","hentry","category-data-tier-applications-dac","category-sql-server-2012","category-sql-server-data-tools"],"yoast_head":"\nThe Rest of the Story: Co-existing VS2010 and SSDT database projects - 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\/the-rest-of-the-story-co-existing-vs2010-and-ssdt-database-projects\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"The Rest of the Story: Co-existing VS2010 and SSDT database projects - Bob Beauchemin\" \/>\n<meta property=\"og:description\" content=\"After my last adventure, I thought it would be interesting to try the "upgrade path" with SSDT and older "Database Projects" (i.e. Visual Studio for Database Professionals, or whatever the last name was before we went to the nice SSDT acronym, I always called them "Data Dude" projects after Gert Drapers, the original Data Dude). […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.sqlskills.com\/blogs\/bobb\/the-rest-of-the-story-co-existing-vs2010-and-ssdt-database-projects\/\" \/>\n<meta property=\"og:site_name\" content=\"Bob Beauchemin\" \/>\n<meta property=\"article:published_time\" content=\"2012-04-17T15:00:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2014-01-20T20:21:47+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=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/bobb\/the-rest-of-the-story-co-existing-vs2010-and-ssdt-database-projects\/\",\"url\":\"https:\/\/www.sqlskills.com\/blogs\/bobb\/the-rest-of-the-story-co-existing-vs2010-and-ssdt-database-projects\/\",\"name\":\"The Rest of the Story: Co-existing VS2010 and SSDT database projects - Bob Beauchemin\",\"isPartOf\":{\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/bobb\/#website\"},\"datePublished\":\"2012-04-17T15:00:00+00:00\",\"dateModified\":\"2014-01-20T20:21:47+00:00\",\"author\":{\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/bobb\/#\/schema\/person\/62bfa986c5b5d28fcffd8b4fc409c73e\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/bobb\/the-rest-of-the-story-co-existing-vs2010-and-ssdt-database-projects\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.sqlskills.com\/blogs\/bobb\/the-rest-of-the-story-co-existing-vs2010-and-ssdt-database-projects\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/bobb\/the-rest-of-the-story-co-existing-vs2010-and-ssdt-database-projects\/#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\":\"The Rest of the Story: Co-existing VS2010 and SSDT database projects\"}]},{\"@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":"The Rest of the Story: Co-existing VS2010 and SSDT database projects - 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\/the-rest-of-the-story-co-existing-vs2010-and-ssdt-database-projects\/","og_locale":"en_US","og_type":"article","og_title":"The Rest of the Story: Co-existing VS2010 and SSDT database projects - Bob Beauchemin","og_description":"After my last adventure, I thought it would be interesting to try the "upgrade path" with SSDT and older "Database Projects" (i.e. Visual Studio for Database Professionals, or whatever the last name was before we went to the nice SSDT acronym, I always called them "Data Dude" projects after Gert Drapers, the original Data Dude). […]","og_url":"https:\/\/www.sqlskills.com\/blogs\/bobb\/the-rest-of-the-story-co-existing-vs2010-and-ssdt-database-projects\/","og_site_name":"Bob Beauchemin","article_published_time":"2012-04-17T15:00:00+00:00","article_modified_time":"2014-01-20T20:21:47+00:00","author":"Bob Beauchemin","twitter_misc":{"Written by":"Bob Beauchemin","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.sqlskills.com\/blogs\/bobb\/the-rest-of-the-story-co-existing-vs2010-and-ssdt-database-projects\/","url":"https:\/\/www.sqlskills.com\/blogs\/bobb\/the-rest-of-the-story-co-existing-vs2010-and-ssdt-database-projects\/","name":"The Rest of the Story: Co-existing VS2010 and SSDT database projects - Bob Beauchemin","isPartOf":{"@id":"https:\/\/www.sqlskills.com\/blogs\/bobb\/#website"},"datePublished":"2012-04-17T15:00:00+00:00","dateModified":"2014-01-20T20:21:47+00:00","author":{"@id":"https:\/\/www.sqlskills.com\/blogs\/bobb\/#\/schema\/person\/62bfa986c5b5d28fcffd8b4fc409c73e"},"breadcrumb":{"@id":"https:\/\/www.sqlskills.com\/blogs\/bobb\/the-rest-of-the-story-co-existing-vs2010-and-ssdt-database-projects\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.sqlskills.com\/blogs\/bobb\/the-rest-of-the-story-co-existing-vs2010-and-ssdt-database-projects\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.sqlskills.com\/blogs\/bobb\/the-rest-of-the-story-co-existing-vs2010-and-ssdt-database-projects\/#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":"The Rest of the Story: Co-existing VS2010 and SSDT database projects"}]},{"@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\/493","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=493"}],"version-history":[{"count":0,"href":"https:\/\/www.sqlskills.com\/blogs\/bobb\/wp-json\/wp\/v2\/posts\/493\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.sqlskills.com\/blogs\/bobb\/wp-json\/wp\/v2\/media?parent=493"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/bobb\/wp-json\/wp\/v2\/categories?post=493"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/bobb\/wp-json\/wp\/v2\/tags?post=493"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}