{"id":39576,"date":"2022-03-24T08:00:00","date_gmt":"2022-03-24T15:00:00","guid":{"rendered":""},"modified":"2024-04-19T10:42:23","modified_gmt":"2024-04-19T17:42:23","slug":"move-end-of-support-sql-server-2012-to-azure-virtual-machines-and-save","status":"publish","type":"post","link":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2022\/03\/24\/move-end-of-support-sql-server-2012-to-azure-virtual-machines-and-save\/","title":{"rendered":"Move end-of-support SQL Server 2012 to Azure Virtual Machines and save"},"content":{"rendered":"\n

The end of support for SQL Server 2012<\/a> is rapidly approaching on July 12, 2022<\/strong>. After end of support, no more security patches will be issued unless you take action to protect your SQL Server 2012 with Extended Security Updates (ESU). If you\u2019re still weighing the options, this blog can help choose the best course of action to keep your SQL Server protected and supported. We evaluated different choices including upgrading, purchasing Extended Security Updates, and moving to Azure for free security patches. And we found that for many people, moving SQL Server 2012 to the cloud can have the lowest total cost of ownership\u2014as much as 69 percent less than purchasing Extended Security Updates on-premises<\/strong>.  <\/p>\n\n\n\n

Stay protected on-premises or in Azure <\/h2>\n\n\n\n

If you need more time to upgrade or modernize, you can still run your workloads in the existing infrastructure. However, to protect databases after the end of support deadline, you will have to purchase three more years of Extended Security Updates. The cost of on-premises Extended Security Updates is 75 percent of the price of a SQL Server license in year one, 100 percent of the price of a SQL Server license in year two, and 125 percent of the price of a SQL Server license in year three.<\/p>\n\n\n\n

If you choose to modernize on-premises, upgrading to SQL Server 2019<\/a> allows you to benefit from industry-leading security and performance, the ability to break down data silos, added business continuity scenarios, and deployment flexibility. You can get access to the latest version of SQL Server through the New Version Rights benefit of Software Assurance<\/a>, or by purchasing new SQL Server licenses<\/a>.<\/p>\n\n\n\n

If you decide to move SQL Server to Azure Virtual Machines, you will gain access to free Extended Security Updates for up to three years after SQL Server 2012 end of support. We continue to innovate to make Azure Virtual Machines the best destination for your SQL Server<\/a> by adding to our hardware options and suite of free manageability capabilities enabled by SQL Server IaaS Agent extension. Registering with SQL Server IaaS Agent extension also allows you to configure a maintenance window and turn on optional automated patching.<\/p>\n\n\n\n

The free Extended Security Updates offer also extends to other destinations in Azure including Azure Dedicated Host, Azure VMWare Solution, and hybrid destinations such as Azure Stack HCI.<\/p>\n\n\n\n

\"From<\/figure>\n<\/div>\n\n\n\n

If you\u2019re ready to not only move to Azure but to modernize to a managed database, Azure SQL Managed Instance<\/a> is a fully managed service with evergreen SQL that never needs to be patched or upgraded. With SQL Managed Instance, you can confidently modernize your existing apps at scale by combining your experience with familiar tools, skills, and resources and do more with what you already have.<\/p>\n\n\n\n

Customers like Forever 21<\/a> made the decision to migrate end-of-life SQL Server workloads to Azure, moving from on-premises to Windows Server, and SQL Server to Azure Virtual Machines. This allowed Forever 21 the flexibility to scale resources at will. To make the deal even better, Forever 21<\/a> used Azure Hybrid Benefit which lowered their total cost of ownership by allowing use of existing on-premises Windows Server and SQL Server licenses in Azure. This resulted in a 20 percent annual saving on software licenses, and server and network infrastructure, amounting to $250,000.<\/p>\n\n\n\n

\n

\u201cWith Azure, we were able to cope with more sessions and more online customers than we\u2019d ever seen\u2014by almost 50 percent. Ultimately, by scaling our presence in Azure, we got through our biggest holiday season ever without a hitch.\u201d<\/em>\u2014Kevin Diamond, Head of Global E-Commerce, Forever 21<\/p>\n<\/blockquote>\n\n\n\n

Reaping the benefits of moving to Azure<\/h2>\n\n\n\n

You may feel that your current SQL Server infrastructure is fully depreciated and staying on it is low- or no-cost. Or you may be concerned about migration costs. By moving to Azure, not only do you save with free Extended Security Updates, but you can also save with Azure Hybrid Benefit for Windows Server and SQL Server, allowing you to reuse existing licenses. Migrating your application to Azure enables you to strengthen your information security, while consistently meeting compliance regulations.  <\/p>\n\n\n\n

Example one: Purchasing Extended Security Updates versus free updates in Azure  <\/h2>\n\n\n\n

When it comes to deciding to upgrade, migrate, or stay in place, the numbers year after year tell the entire story. Running your end-of-life SQL Server on Azure Virtual Machines allows you to both strengthen your security and save. Here\u2019s how:   <\/p>\n\n\n\n