There's also an inherent risk of running into issues during an in-place upgrade process.Ĭomplexity: If you're on Windows Server 2008 or Windows Server 2008 R2, you also need to upgrade the OS as the newer versions of SQL Server may not be supported on those Windows versions. You have to buy, maintain, and manage your own hardware and software.ĭowntime: There could be downtime depending on your upgrade strategy. For more information, see Compatibility Certification.Ĭost: This approach requires the biggest up-front investment and the most ongoing management. An application only needs to be fully recertified when it needs to use features that are gated by a newer database compatibility setting.
Low risk for database applications: When the database compatibility is at the same level as the legacy system, existing database applications are protected from functional and performance changes that can have detrimental effects. Wide applicability: Applicable for database applications of any kind, including OLTP systems and data warehousing. Latest technology: New SQL Server versions introduce innovations that include performance, scalability, and high-availability features, and improved security.Ĭontrol: You have the most control over features and scalability, because you manage both hardware and software.įamiliar environment: If you're upgrading from an older version of SQL Server, this environment is the most similar. This option gives you environmental consistency, allows you to use the latest feature set, and adopts the new version's support lifecycle. Once your SQL Server has reached the end of support, you can choose to upgrade to a newer and supported version of SQL Server. This article describes the benefits and considerations for each approach, with more resources to help guide your decision-making process.
#Ms sql studio 2008 for free#
Migrate your workload to an Azure Virtual Machine as-is for free Extended Security Updates.Once your SQL Server has reached the end of support stage, you can choose to: For more information about the Microsoft Lifecycle, see Microsoft Lifecycle Policy. Extended support includes only security updates.Įnd of support (also sometimes known as end of life) indicates that a product has reached the end of its lifecycle, and servicing and support is no longer available for the product.Mainstream support includes functional, performance, scalability and security updates.Understand the SQL Server lifecycleĮach version of SQL Server is backed by a minimum of 10 years support, which includes five years in mainstream support, and five years in extended support: This article explains your options for addressing SQL Server products that have reached end of support. Applies to: SQL Server 2008 SQL Server 2008 R2 SQL Server 2012 (11.x)
0 kommentar(er)
