{"id":15193,"date":"2016-03-15T13:00:24","date_gmt":"2016-03-15T20:00:24","guid":{"rendered":""},"modified":"2024-01-22T22:50:26","modified_gmt":"2024-01-23T06:50:26","slug":"time-is-running-out-upgrade-sql-server-2005-now","status":"publish","type":"post","link":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2016\/03\/15\/time-is-running-out-upgrade-sql-server-2005-now\/","title":{"rendered":"Time is running out: Upgrade SQL Server 2005 now"},"content":{"rendered":"<p>Less than one month remains before <a href=\"https:\/\/www.microsoft.com\/en-us\/server-cloud\/products\/sql-server-2005\/?wt.mc_id=WW_CE_MU_OO_BLOG_NONE\">support ends for SQL Server 2005<\/a> on <strong>April 12, 2016<\/strong>. If you\u2019re still using this version or other legacy versions of SQL Server, there\u2019s never been a better time to upgrade to <a href=\"https:\/\/www.microsoft.com\/en-us\/server-cloud\/products\/sql-server\/?wt.mc_id=WW_CE_MU_OO_BLOG_NONE\">SQL Server 2014<\/a> and <a href=\"https:\/\/azure.microsoft.com\/en-us\/services\/sql-database\/?wt.mc_id=WW_CE_MU_OO_BLOG_NONE\">Microsoft Azure SQL Database<\/a> to safeguard your business and reap all the benefits of a modern data platform.<\/p>\n<p>With just a few weeks remaining, we wanted to remind you of the many resources available to help you make the move:\n<\/p>\n<h2>Understand the process<\/h2>\n<p>Read our blog post series for a full description of the upgrade process:<\/p>\n<ul>\n<li>\n<a href=\"https:\/\/blogs.technet.microsoft.com\/dataplatforminsider\/2015\/12\/10\/planning-an-efficient-upgrade-from-sql-server-2005-step-1-of-3\/?wt.mc_id=WW_CE_MU_OO_BLOG_NONE\">Step One<\/a>: Understand and map out your database and its dependencies.<\/li>\n<li>\n<a href=\"https:\/\/blogs.technet.microsoft.com\/dataplatforminsider\/2015\/12\/15\/planning-an-efficient-upgrade-from-sql-server-2005-step-2-of-3\/?wt.mc_id=WW_CE_MU_OO_BLOG_NONE\">Step Two<\/a>: Target the destination for each application and workload.<\/li>\n<li>\n<a href=\"https:\/\/blogs.technet.microsoft.com\/dataplatforminsider\/2015\/12\/17\/planning-an-efficient-upgrade-from-sql-server-2005-step-3-of-3\/?wt.mc_id=WW_CE_MU_OO_BLOG_NONE\">Step Three<\/a>: Identify your upgrade strategy.<\/li>\n<\/ul>\n<p>Visit the <a href=\"https:\/\/www.microsoft.com\/en-us\/server-cloud\/products\/sql-server-2005\/?wt.mc_id=WW_CE_MU_OO_BLOG_NONE\">SQL Server 2005 End of Support page<\/a> for detailed information on planning and executing the migration, along with options for your new database strategy.<\/p>\n<h2>Understand the benefits<\/h2>\n<ul>\n<li>Download the white paper, <a href=\"https:\/\/info.microsoft.com\/CO-SQL-CNTNT-FY16-09Sep-14-ModernizationDirOnMFST-Register.html?wt.mc_id=WW_CE_MU_OO_BLOG_NONE\"><em>Migrating from SQL Server 2005<\/em><\/a>.<\/li>\n<li>Download the data sheet to <a href=\"https:\/\/info.microsoft.com\/rs\/157-GQE-382\/images\/EN-CNTNT-Infographic-UpgradeSQL2005Datasheet.pdf?wt.mc_id=WW_CE_MU_OO_BLOG_NONE\">see what you have to gain<\/a> by upgrading to Microsoft SQL Server 2014.<\/li>\n<\/ul>\n<h2>Plan your upgrade<\/h2>\n<ul>\n<li>Assess your IT environment with the <a href=\"https:\/\/technet.microsoft.com\/en-us\/solutionaccelerators\/dd537566.aspx?wt.mc_id=mkto_EM55771A1LA1&amp;ls=email&amp;mkt_tok=3RkMMJWWfF9wsRomrfCcI63Em2iQPJWpsrB0B%2FDC18kX3RUrJbqXagfind1SFJk7a8C6XFNFRN1G8SkVSbjH?wt.mc_id=WW_CE_MU_OO_BLOG_NONE\">Microsoft Assessment and Planning Toolkit<\/a>.<\/li>\n<li>Get started yourself with the <a href=\"http:\/\/download.microsoft.com\/download\/7\/1\/5\/715BDFA7-51B6-4D7B-AF17-61E78C7E538F\/SQL_Server_2014_Upgrade_technical_guide.pdf?wt.mc_id=WW_CE_MU_OO_BLOG_NONE\">SQL Server 2014 Upgrade Technical Guide<\/a>.<\/li>\n<li>Work with <a href=\"https:\/\/www.microsoft.com\/en-us\/microsoftservices\/campaigns\/enterprise-modernization.aspx?wt.mc_id=WW_CE_MU_OO_BLOG_NONE\">Microsoft Services<\/a> or a <a href=\"https:\/\/pinpoint.microsoft.com\/en-US\/search?type=companies&amp;keyword=&amp;market=&amp;geoRadius=5&amp;competency=100004&amp;page=0?wt.mc_id=WW_CE_MU_OO_BLOG_NONE\">Microsoft partner<\/a> to assist you in your upgrade and planning.<\/li>\n<li>Don\u2019t forget that SQL Server 2005 Express will run out of support too. Check out this <a href=\"https:\/\/www.youtube.com\/user\/MSCloudOS\/search?query=sql+server+2005+express\">video series<\/a> for help with your Express upgrades.<\/li>\n<\/ul>\n<h4>\n<a href=\"https:\/\/www.microsoft.com\/en-us\/server-cloud\/products\/sql-server\/Purchasing.aspx?wt.mc_id=WW_CE_MU_OO_BLOG_NONE\">Upgrade to SQL Server 2014 now<\/a>.<\/h4>\n<p>Microsoft\u2019s deep commitment to this industry leading technology continues with the availability of the release candidate for SQL Server 2016, the biggest leap forward in Microsoft\u2019s data platform history. SQL Server 2016 will include real-time operational analytics, rich visualizations on mobile devices, built-in advanced analytics, new advanced security technology, and new hybrid cloud scenarios.<\/p>\n<p>See what\u2019s coming in <a href=\"https:\/\/www.microsoft.com\/en-us\/server-cloud\/products\/sql-server-2016\/?wt.mc_id=WW_CE_MU_OO_BLOG_NONE\">SQL Server 2016<\/a>.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Less than one month remains before support ends for SQL Server 2005 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":[2448],"topic":[],"coauthors":[2487],"class_list":["post-15193","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>Time is running out: Upgrade SQL Server 2005 now - 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\/03\/15\/time-is-running-out-upgrade-sql-server-2005-now\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Time is running out: Upgrade SQL Server 2005 now - Microsoft SQL Server Blog\" \/>\n<meta property=\"og:description\" content=\"Less than one month remains before support ends for SQL Server 2005 on April 12, 2016.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2016\/03\/15\/time-is-running-out-upgrade-sql-server-2005-now\/\" \/>\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-03-15T20:00:24+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-01-23T06:50:26+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=\"1 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\/03\/15\/time-is-running-out-upgrade-sql-server-2005-now\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2016\/03\/15\/time-is-running-out-upgrade-sql-server-2005-now\/\"},\"author\":[{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/author\/sql-server-team\/\",\"@type\":\"Person\",\"@name\":\"SQL Server Team\"}],\"headline\":\"Time is running out: Upgrade SQL Server 2005 now\",\"datePublished\":\"2016-03-15T20:00:24+00:00\",\"dateModified\":\"2024-01-23T06:50:26+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2016\/03\/15\/time-is-running-out-upgrade-sql-server-2005-now\/\"},\"wordCount\":314,\"commentCount\":1,\"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\/03\/15\/time-is-running-out-upgrade-sql-server-2005-now\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2016\/03\/15\/time-is-running-out-upgrade-sql-server-2005-now\/\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2016\/03\/15\/time-is-running-out-upgrade-sql-server-2005-now\/\",\"name\":\"Time is running out: Upgrade SQL Server 2005 now - Microsoft SQL Server Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#website\"},\"datePublished\":\"2016-03-15T20:00:24+00:00\",\"dateModified\":\"2024-01-23T06:50:26+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2016\/03\/15\/time-is-running-out-upgrade-sql-server-2005-now\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2016\/03\/15\/time-is-running-out-upgrade-sql-server-2005-now\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2016\/03\/15\/time-is-running-out-upgrade-sql-server-2005-now\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Time is running out: Upgrade SQL Server 2005 now\"}]},{\"@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":"Time is running out: Upgrade SQL Server 2005 now - 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\/03\/15\/time-is-running-out-upgrade-sql-server-2005-now\/","og_locale":"en_US","og_type":"article","og_title":"Time is running out: Upgrade SQL Server 2005 now - Microsoft SQL Server Blog","og_description":"Less than one month remains before support ends for SQL Server 2005 on April 12, 2016.","og_url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2016\/03\/15\/time-is-running-out-upgrade-sql-server-2005-now\/","og_site_name":"Microsoft SQL Server Blog","article_publisher":"http:\/\/www.facebook.com\/sqlserver","article_published_time":"2016-03-15T20:00:24+00:00","article_modified_time":"2024-01-23T06:50:26+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":"1 min read"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2016\/03\/15\/time-is-running-out-upgrade-sql-server-2005-now\/#article","isPartOf":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2016\/03\/15\/time-is-running-out-upgrade-sql-server-2005-now\/"},"author":[{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/author\/sql-server-team\/","@type":"Person","@name":"SQL Server Team"}],"headline":"Time is running out: Upgrade SQL Server 2005 now","datePublished":"2016-03-15T20:00:24+00:00","dateModified":"2024-01-23T06:50:26+00:00","mainEntityOfPage":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2016\/03\/15\/time-is-running-out-upgrade-sql-server-2005-now\/"},"wordCount":314,"commentCount":1,"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\/03\/15\/time-is-running-out-upgrade-sql-server-2005-now\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2016\/03\/15\/time-is-running-out-upgrade-sql-server-2005-now\/","url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2016\/03\/15\/time-is-running-out-upgrade-sql-server-2005-now\/","name":"Time is running out: Upgrade SQL Server 2005 now - Microsoft SQL Server Blog","isPartOf":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#website"},"datePublished":"2016-03-15T20:00:24+00:00","dateModified":"2024-01-23T06:50:26+00:00","breadcrumb":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2016\/03\/15\/time-is-running-out-upgrade-sql-server-2005-now\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2016\/03\/15\/time-is-running-out-upgrade-sql-server-2005-now\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2016\/03\/15\/time-is-running-out-upgrade-sql-server-2005-now\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/"},{"@type":"ListItem","position":2,"name":"Time is running out: Upgrade SQL Server 2005 now"}]},{"@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\/15193","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=15193"}],"version-history":[{"count":0,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/posts\/15193\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/media?parent=15193"}],"wp:term":[{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/post_tag?post=15193"},{"taxonomy":"product","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/product?post=15193"},{"taxonomy":"content-type","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/content-type?post=15193"},{"taxonomy":"topic","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/topic?post=15193"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/coauthors?post=15193"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}