{"id":17485,"date":"2016-10-27T10:45:12","date_gmt":"2016-10-27T17:45:12","guid":{"rendered":"https:\/\/blogs.technet.microsoft.com\/dataplatforminsider\/?p=17485"},"modified":"2024-01-22T22:50:36","modified_gmt":"2024-01-23T06:50:36","slug":"upgrade-with-data-migration-assistant-2-0-and-database-experimentation-assistant-preview","status":"publish","type":"post","link":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2016\/10\/27\/upgrade-with-data-migration-assistant-2-0-and-database-experimentation-assistant-preview\/","title":{"rendered":"Upgrade with Data Migration Assistant 2.0 and Database Experimentation Assistant Preview"},"content":{"rendered":"<p>This week as part of Joseph Sirosh\u2019s PASS Summit 2016 keynote, Microsoft announced general availability of <span style=\"color: #0000ff\"><a href=\"https:\/\/www.microsoft.com\/en-us\/download\/details.aspx?id=53595\">Data Migration Assistant v2.0<\/a> <\/span>and the first public preview for <a target=\"_blank\" href=\"https:\/\/www.microsoft.com\/en-us\/download\/details.aspx?id=54090\" rel=\"noopener\">Database Experimentation Assistant<\/a>. Both tools are part of Microsoft\u2019s strategy to make upgrade and migration from earlier versions of SQL Server as seamless and low risk as possible. Database Migration Assistant is a free tool that reduces the effort required to upgrade SQL Server by detecting compatibility issues that can impact database functionality after an upgrade. Database Experimentation Assistant technical preview is a new free tool that enables customers to gather performance insights for upgrades by conducting experiments across two SQL Server versions using production workloads.<\/p>\n<p>Database Migration Assistant automates the potentially overwhelming process of checking database schema and static objects for breaking changes from prior versions.\u00a0 It also recommends performance and reliability improvements for your target environment. New in this version of Data Migration Assistant is the migration workflow: the capability to move your schema, data, and uncontained objects including user logins from a source server to a SQL Server 2012, 2014 or 2016 target server, either on-premises or in an Azure VM. Database Migration Assistant replaces the previous SQL Server Upgrade Advisor tool.<\/p>\n<p>Database Experimentation Assistant is a new A\/B testing solution for SQL Server upgrades. Customers who are upgrading from SQL Server 2005 and above to any new version of the SQL Server can capture key performance insights using a real-world workload. The tool performs statistical analysis on traces captured from two versions of SQL Server and offers the ability to visualize potential performance regressions and errors via analysis reporting. These insights can help build confidence about upgrade among database administrators, IT management and application owners by minimizing upgrade risks.<\/p>\n<p>Together these two tools can help you identify upgrade opportunities, minimize risk, and execute database migrations for a faster, smoother upgrade process. You can get started with your upgrade assessment now by downloading a copy of <span style=\"color: #0000ff\"><a href=\"https:\/\/www.microsoft.com\/en-us\/download\/details.aspx?id=53595\">Data Migration Assistant<\/a><\/span> from the Microsoft Download Center. To preview the new A\/B test tool, download a copy of Database Experimentation Assistant.\u00a0 To learn more about SQL Server 2016\u2019s capabilities for building intelligent, mission critical applications you can start a <span style=\"color: #0000ff\"><a href=\"https:\/\/www.microsoft.com\/en-us\/evalcenter\/evaluate-sql-server-2016\">trial evaluation of SQL Server 2016<\/a><\/span> from the TechNet Evaluation Center.<\/p>\n<p>Learn more about tools for upgrading and migrating SQL Server databases with these additional resources:\n<\/p>\n<ul>\n<li><a href=\"https:\/\/blogs.msdn.microsoft.com\/datamigration\/dma\/\">Data Migration Blog<\/a><\/li>\n<li><a href=\"https:\/\/go.microsoft.com\/fwlink\/?linkid=832571\">Now available: Data Migration Assistant (DMA) v2.0<\/a><\/li>\n<li><a href=\"https:\/\/blogs.msdn.microsoft.com\/datamigration\/2016\/10\/24\/database-experimentation-assistant-v1-0-preview\/\">Read more: Database Experimentation Assistant Technical Preview<\/a><\/li>\n<li><span style=\"color: #3366ff\"><a href=\"https:\/\/msdn.microsoft.com\/library\/bb677622.aspx\">SQL Server 2016 Upgrade Guide<\/a><\/span><\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>This week as part of Joseph Sirosh\u2019s PASS Summit 2016 keynote, Microsoft announced general availability of Data Migration Assistant v2.0 and the first public preview for Database Experimentation Assistant. Both tools are part of Microsoft\u2019s strategy to make upgrade and migration from earlier versions of SQL Server as seamless and low risk as possible.<\/p>\n","protected":false},"author":1457,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"ep_exclude_from_search":false,"_classifai_error":"","_classifai_text_to_speech_error":"","footnotes":""},"post_tag":[],"product":[],"content-type":[2448],"topic":[],"coauthors":[2487],"class_list":["post-17485","post","type-post","status-publish","format-standard","hentry","content-type-updates"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.2 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Upgrade with Data Migration Assistant 2.0 and Database Experimentation Assistant Preview - Microsoft SQL Server Blog<\/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.microsoft.com\/en-us\/sql-server\/blog\/2016\/10\/27\/upgrade-with-data-migration-assistant-2-0-and-database-experimentation-assistant-preview\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Upgrade with Data Migration Assistant 2.0 and Database Experimentation Assistant Preview - Microsoft SQL Server Blog\" \/>\n<meta property=\"og:description\" content=\"This week as part of Joseph Sirosh\u2019s PASS Summit 2016 keynote, Microsoft announced general availability of Data Migration Assistant v2.0 and the first public preview for Database Experimentation Assistant. Both tools are part of Microsoft\u2019s strategy to make upgrade and migration from earlier versions of SQL Server as seamless and low risk as possible.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2016\/10\/27\/upgrade-with-data-migration-assistant-2-0-and-database-experimentation-assistant-preview\/\" \/>\n<meta property=\"og:site_name\" content=\"Microsoft SQL Server Blog\" \/>\n<meta property=\"article:publisher\" content=\"http:\/\/www.facebook.com\/sqlserver\" \/>\n<meta property=\"article:published_time\" content=\"2016-10-27T17:45:12+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-01-23T06:50:36+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/08\/cropped-microsoft_logo_element.png\" \/>\n\t<meta property=\"og:image:width\" content=\"512\" \/>\n\t<meta property=\"og:image:height\" content=\"512\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"SQL Server Team\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@SQLServer\" \/>\n<meta name=\"twitter:site\" content=\"@SQLServer\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"SQL Server Team\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 min read\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2016\/10\/27\/upgrade-with-data-migration-assistant-2-0-and-database-experimentation-assistant-preview\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2016\/10\/27\/upgrade-with-data-migration-assistant-2-0-and-database-experimentation-assistant-preview\/\"},\"author\":[{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/author\/sql-server-team\/\",\"@type\":\"Person\",\"@name\":\"SQL Server Team\"}],\"headline\":\"Upgrade with Data Migration Assistant 2.0 and Database Experimentation Assistant Preview\",\"datePublished\":\"2016-10-27T17:45:12+00:00\",\"dateModified\":\"2024-01-23T06:50:36+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2016\/10\/27\/upgrade-with-data-migration-assistant-2-0-and-database-experimentation-assistant-preview\/\"},\"wordCount\":420,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2016\/10\/27\/upgrade-with-data-migration-assistant-2-0-and-database-experimentation-assistant-preview\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2016\/10\/27\/upgrade-with-data-migration-assistant-2-0-and-database-experimentation-assistant-preview\/\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2016\/10\/27\/upgrade-with-data-migration-assistant-2-0-and-database-experimentation-assistant-preview\/\",\"name\":\"Upgrade with Data Migration Assistant 2.0 and Database Experimentation Assistant Preview - Microsoft SQL Server Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#website\"},\"datePublished\":\"2016-10-27T17:45:12+00:00\",\"dateModified\":\"2024-01-23T06:50:36+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2016\/10\/27\/upgrade-with-data-migration-assistant-2-0-and-database-experimentation-assistant-preview\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2016\/10\/27\/upgrade-with-data-migration-assistant-2-0-and-database-experimentation-assistant-preview\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2016\/10\/27\/upgrade-with-data-migration-assistant-2-0-and-database-experimentation-assistant-preview\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Upgrade with Data Migration Assistant 2.0 and Database Experimentation Assistant Preview\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#website\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/\",\"name\":\"Microsoft SQL Server Blog\",\"description\":\"Official News from Microsoft\u2019s Information Platform\",\"publisher\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization\",\"name\":\"Microsoft SQL Server Blog\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2019\/08\/Microsoft-Logo.png\",\"contentUrl\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2019\/08\/Microsoft-Logo.png\",\"width\":259,\"height\":194,\"caption\":\"Microsoft SQL Server Blog\"},\"image\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"http:\/\/www.facebook.com\/sqlserver\",\"https:\/\/x.com\/SQLServer\",\"https:\/\/www.youtube.com\/user\/MSCloudOS\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Upgrade with Data Migration Assistant 2.0 and Database Experimentation Assistant Preview - Microsoft SQL Server Blog","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.microsoft.com\/en-us\/sql-server\/blog\/2016\/10\/27\/upgrade-with-data-migration-assistant-2-0-and-database-experimentation-assistant-preview\/","og_locale":"en_US","og_type":"article","og_title":"Upgrade with Data Migration Assistant 2.0 and Database Experimentation Assistant Preview - Microsoft SQL Server Blog","og_description":"This week as part of Joseph Sirosh\u2019s PASS Summit 2016 keynote, Microsoft announced general availability of Data Migration Assistant v2.0 and the first public preview for Database Experimentation Assistant. Both tools are part of Microsoft\u2019s strategy to make upgrade and migration from earlier versions of SQL Server as seamless and low risk as possible.","og_url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2016\/10\/27\/upgrade-with-data-migration-assistant-2-0-and-database-experimentation-assistant-preview\/","og_site_name":"Microsoft SQL Server Blog","article_publisher":"http:\/\/www.facebook.com\/sqlserver","article_published_time":"2016-10-27T17:45:12+00:00","article_modified_time":"2024-01-23T06:50:36+00:00","og_image":[{"width":512,"height":512,"url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/08\/cropped-microsoft_logo_element.png","type":"image\/png"}],"author":"SQL Server Team","twitter_card":"summary_large_image","twitter_creator":"@SQLServer","twitter_site":"@SQLServer","twitter_misc":{"Written by":"SQL Server Team","Est. reading time":"2 min read"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2016\/10\/27\/upgrade-with-data-migration-assistant-2-0-and-database-experimentation-assistant-preview\/#article","isPartOf":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2016\/10\/27\/upgrade-with-data-migration-assistant-2-0-and-database-experimentation-assistant-preview\/"},"author":[{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/author\/sql-server-team\/","@type":"Person","@name":"SQL Server Team"}],"headline":"Upgrade with Data Migration Assistant 2.0 and Database Experimentation Assistant Preview","datePublished":"2016-10-27T17:45:12+00:00","dateModified":"2024-01-23T06:50:36+00:00","mainEntityOfPage":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2016\/10\/27\/upgrade-with-data-migration-assistant-2-0-and-database-experimentation-assistant-preview\/"},"wordCount":420,"commentCount":0,"publisher":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization"},"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2016\/10\/27\/upgrade-with-data-migration-assistant-2-0-and-database-experimentation-assistant-preview\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2016\/10\/27\/upgrade-with-data-migration-assistant-2-0-and-database-experimentation-assistant-preview\/","url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2016\/10\/27\/upgrade-with-data-migration-assistant-2-0-and-database-experimentation-assistant-preview\/","name":"Upgrade with Data Migration Assistant 2.0 and Database Experimentation Assistant Preview - Microsoft SQL Server Blog","isPartOf":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#website"},"datePublished":"2016-10-27T17:45:12+00:00","dateModified":"2024-01-23T06:50:36+00:00","breadcrumb":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2016\/10\/27\/upgrade-with-data-migration-assistant-2-0-and-database-experimentation-assistant-preview\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2016\/10\/27\/upgrade-with-data-migration-assistant-2-0-and-database-experimentation-assistant-preview\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2016\/10\/27\/upgrade-with-data-migration-assistant-2-0-and-database-experimentation-assistant-preview\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/"},{"@type":"ListItem","position":2,"name":"Upgrade with Data Migration Assistant 2.0 and Database Experimentation Assistant Preview"}]},{"@type":"WebSite","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#website","url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/","name":"Microsoft SQL Server Blog","description":"Official News from Microsoft\u2019s Information Platform","publisher":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization","name":"Microsoft SQL Server Blog","url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2019\/08\/Microsoft-Logo.png","contentUrl":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2019\/08\/Microsoft-Logo.png","width":259,"height":194,"caption":"Microsoft SQL Server Blog"},"image":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#\/schema\/logo\/image\/"},"sameAs":["http:\/\/www.facebook.com\/sqlserver","https:\/\/x.com\/SQLServer","https:\/\/www.youtube.com\/user\/MSCloudOS"]}]}},"msxcm_display_generated_audio":false,"msxcm_animated_featured_image":null,"_links":{"self":[{"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/posts\/17485","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/users\/1457"}],"replies":[{"embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/comments?post=17485"}],"version-history":[{"count":0,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/posts\/17485\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/media?parent=17485"}],"wp:term":[{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/post_tag?post=17485"},{"taxonomy":"product","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/product?post=17485"},{"taxonomy":"content-type","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/content-type?post=17485"},{"taxonomy":"topic","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/topic?post=17485"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/coauthors?post=17485"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}