{"id":14541,"date":"2015-12-10T09:00:00","date_gmt":"2015-12-10T17:00:00","guid":{"rendered":"https:\/\/blogs.technet.microsoft.com\/dataplatforminsider\/2015\/12\/10\/planning-an-efficient-upgrade-from-sql-server-2005-step-1-of-3\/"},"modified":"2024-01-22T22:50:22","modified_gmt":"2024-01-23T06:50:22","slug":"planning-an-efficient-upgrade-from-sql-server-2005-step-1-of-3","status":"publish","type":"post","link":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2015\/12\/10\/planning-an-efficient-upgrade-from-sql-server-2005-step-1-of-3\/","title":{"rendered":"Planning an efficient upgrade from SQL Server 2005: Step 1 of 3"},"content":{"rendered":"

Step 1: Discover what\u2019s in your database environment<\/span><\/strong><\/em> <\/span><\/p>\n

Upgrading a database can seem daunting. Fortunately, Microsoft offers exceptional tools and support to help you smoothly upgrade from SQL Server 2005 to SQL Server 2014 and Microsoft Azure SQL Database before the end-of-support deadline on April 12, 2016. In this series of three blog posts, we\u2019ll review three steps for your that can help make this a manageable and simplified process.<\/span><\/p>\n

To make your upgrade more efficient with less unintended downtime, it\u2019s important to plan before getting started. The first step in your planning process is to discover what\u2019s in your database environment: workloads, virtual or physical servers, what\u2019s running on which versions and editions of software, and so on. For example, you\u2019ll want to find out if SQL Server 2005 is running in your environment. Then, discover if any applications are running on SQL Server 2005 so you can protect critical data after the end-of-support date.<\/span><\/p>\n

One way to gather this information is to run the Microsoft Assessment and Planning Toolkit, which automates the process of gathering data about your database environment. It can also help you find unidentified databases that might be impacted by end of support. <\/span>Microsoft Services<\/span><\/a> and <\/span>Microsoft Partners<\/span><\/a> also provide offerings to help you do a detailed assessment of your database environment and recommend next steps. Finding the right partner can greatly reduce work and worries on an upgrade.<\/span><\/p>\n

If you are running an assessment on your own, check out the recommended tasks for the discovery step below.<\/span><\/p>\n

Assess your database environment with an automated tool<\/h1>\n

Run the <\/span>Microsoft Assessment and Planning (MAP) Toolkit<\/span><\/a>. The MAP toolkit is an agentless, automated inventory, assessment and reporting tool that gives you a complete, network-wide inventory of database instances, identifies different software editions and assesses hardware used. The wide-ranging details of databases and server instances that MAP provides are vital information you can use to consolidate databases and better use hardware and database resources.<\/span><\/p>\n

Document application workloads and dependencies<\/h1>\n
    \n
  • Identify in-house applications.<\/strong> When documenting and identifying which standalone, in-house applications to upgrade, it\u2019s good to have a clear understanding of the application you\u2019re targeting for upgrade. <\/span><\/li>\n
  • Identify ISV applications.<\/strong> Migrating applications from independent software vendors requires you identify ISV licensing policies and issues, and develop upgrade strategies different from those for in-house applications. <\/span><\/li>\n
  • Find documentation for non-default configurations.<\/strong> If you have a customized SQL Server instance, find out if anyone documented it before you begin the migration. Your database administrators will need this documentation in the new database environment. <\/span><\/li>\n
  • Validate inter-application connectivity.<\/strong> A key dependency is to identify applications that connect to the SQL Server database you\u2019re upgrading. You\u2019ll need to keep those applications connected when you upgrade the database. <\/span><\/li>\n<\/ul>\n

    Understand usage and compatibility requirements<\/h1>\n
      \n
    • Understand application usage and outage windows.<\/strong> Because databases are more than just data and log files sitting on storage somewhere, you\u2019ll need to fit together many pieces of the DB puzzle \u2014 application, storage, operating system, network, and so on \u2014 to minimize downtime. <\/span><\/li>\n
    • Assess compatibility requirements.<\/strong> When planning for a SQL Server database upgrade, you\u2019ll want to understand what features are deprecated, discontinued or changed in the new version. Being aware of these changes in advance helps you prevent performance problems and issues related to application availability. <\/span><\/li>\n<\/ul>\n

      In the next post in this series, we\u2019ll talk about choosing a target destination for workloads that you\u2019re upgrading. Leveraging the data you\u2019ve gathered in this step, you\u2019ll now have the opportunity to evaluate your current data infrastructure. You can then upgrade to solutions that streamline your investment by moving data to the cloud or by consolidating it.<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"

      Step 1: Discover what\u2019s in your database environment Upgrading a database can seem daunting. Fortunately, Microsoft offers exceptional tools and support to help you smoothly upgrade from SQL Server 2005 to SQL Server 2014 and Microsoft Azure SQL Database before the end-of-support deadline on April 12, 2016.<\/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":[2424,2448],"topic":[],"coauthors":[2487],"class_list":["post-14541","post","type-post","status-publish","format-standard","hentry","content-type-best-practices","content-type-updates"],"yoast_head":"\nPlanning an efficient upgrade from SQL Server 2005: Step 1 of 3 - 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\/2015\/12\/10\/planning-an-efficient-upgrade-from-sql-server-2005-step-1-of-3\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Planning an efficient upgrade from SQL Server 2005: Step 1 of 3 - Microsoft SQL Server Blog\" \/>\n<meta property=\"og:description\" content=\"Step 1: Discover what\u2019s in your database environment Upgrading a database can seem daunting. Fortunately, Microsoft offers exceptional tools and support to help you smoothly upgrade from SQL Server 2005 to SQL Server 2014 and Microsoft Azure SQL Database before the end-of-support deadline on April 12, 2016.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2015\/12\/10\/planning-an-efficient-upgrade-from-sql-server-2005-step-1-of-3\/\" \/>\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=\"2015-12-10T17:00:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-01-23T06:50:22+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\/2015\/12\/10\/planning-an-efficient-upgrade-from-sql-server-2005-step-1-of-3\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2015\/12\/10\/planning-an-efficient-upgrade-from-sql-server-2005-step-1-of-3\/\"},\"author\":[{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/author\/sql-server-team\/\",\"@type\":\"Person\",\"@name\":\"SQL Server Team\"}],\"headline\":\"Planning an efficient upgrade from SQL Server 2005: Step 1 of 3\",\"datePublished\":\"2015-12-10T17:00:00+00:00\",\"dateModified\":\"2024-01-23T06:50:22+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2015\/12\/10\/planning-an-efficient-upgrade-from-sql-server-2005-step-1-of-3\/\"},\"wordCount\":619,\"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\/2015\/12\/10\/planning-an-efficient-upgrade-from-sql-server-2005-step-1-of-3\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2015\/12\/10\/planning-an-efficient-upgrade-from-sql-server-2005-step-1-of-3\/\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2015\/12\/10\/planning-an-efficient-upgrade-from-sql-server-2005-step-1-of-3\/\",\"name\":\"Planning an efficient upgrade from SQL Server 2005: Step 1 of 3 - Microsoft SQL Server Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#website\"},\"datePublished\":\"2015-12-10T17:00:00+00:00\",\"dateModified\":\"2024-01-23T06:50:22+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2015\/12\/10\/planning-an-efficient-upgrade-from-sql-server-2005-step-1-of-3\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2015\/12\/10\/planning-an-efficient-upgrade-from-sql-server-2005-step-1-of-3\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2015\/12\/10\/planning-an-efficient-upgrade-from-sql-server-2005-step-1-of-3\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Planning an efficient upgrade from SQL Server 2005: Step 1 of 3\"}]},{\"@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":"Planning an efficient upgrade from SQL Server 2005: Step 1 of 3 - 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\/2015\/12\/10\/planning-an-efficient-upgrade-from-sql-server-2005-step-1-of-3\/","og_locale":"en_US","og_type":"article","og_title":"Planning an efficient upgrade from SQL Server 2005: Step 1 of 3 - Microsoft SQL Server Blog","og_description":"Step 1: Discover what\u2019s in your database environment Upgrading a database can seem daunting. Fortunately, Microsoft offers exceptional tools and support to help you smoothly upgrade from SQL Server 2005 to SQL Server 2014 and Microsoft Azure SQL Database before the end-of-support deadline on April 12, 2016.","og_url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2015\/12\/10\/planning-an-efficient-upgrade-from-sql-server-2005-step-1-of-3\/","og_site_name":"Microsoft SQL Server Blog","article_publisher":"http:\/\/www.facebook.com\/sqlserver","article_published_time":"2015-12-10T17:00:00+00:00","article_modified_time":"2024-01-23T06:50:22+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\/2015\/12\/10\/planning-an-efficient-upgrade-from-sql-server-2005-step-1-of-3\/#article","isPartOf":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2015\/12\/10\/planning-an-efficient-upgrade-from-sql-server-2005-step-1-of-3\/"},"author":[{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/author\/sql-server-team\/","@type":"Person","@name":"SQL Server Team"}],"headline":"Planning an efficient upgrade from SQL Server 2005: Step 1 of 3","datePublished":"2015-12-10T17:00:00+00:00","dateModified":"2024-01-23T06:50:22+00:00","mainEntityOfPage":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2015\/12\/10\/planning-an-efficient-upgrade-from-sql-server-2005-step-1-of-3\/"},"wordCount":619,"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\/2015\/12\/10\/planning-an-efficient-upgrade-from-sql-server-2005-step-1-of-3\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2015\/12\/10\/planning-an-efficient-upgrade-from-sql-server-2005-step-1-of-3\/","url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2015\/12\/10\/planning-an-efficient-upgrade-from-sql-server-2005-step-1-of-3\/","name":"Planning an efficient upgrade from SQL Server 2005: Step 1 of 3 - Microsoft SQL Server Blog","isPartOf":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#website"},"datePublished":"2015-12-10T17:00:00+00:00","dateModified":"2024-01-23T06:50:22+00:00","breadcrumb":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2015\/12\/10\/planning-an-efficient-upgrade-from-sql-server-2005-step-1-of-3\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2015\/12\/10\/planning-an-efficient-upgrade-from-sql-server-2005-step-1-of-3\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2015\/12\/10\/planning-an-efficient-upgrade-from-sql-server-2005-step-1-of-3\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/"},{"@type":"ListItem","position":2,"name":"Planning an efficient upgrade from SQL Server 2005: Step 1 of 3"}]},{"@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\/14541","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=14541"}],"version-history":[{"count":0,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/posts\/14541\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/media?parent=14541"}],"wp:term":[{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/post_tag?post=14541"},{"taxonomy":"product","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/product?post=14541"},{"taxonomy":"content-type","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/content-type?post=14541"},{"taxonomy":"topic","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/topic?post=14541"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/coauthors?post=14541"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}