Select Page

Hyperion and SQL Server: Syncing Versions

Dave Shay | | May 24, 2018

Hyperion administrators and managers have three choices for storing valuable enterprise data: IBM DB2, Microsoft SQL Server, and Oracle database. Companies that choose SQL Server must decide which version of the software best meets their needs – Microsoft currently sells and supports SQL Server 2016, 2014, 2012, 2008 R2, and 2008.

With new SQL Server releases coming roughly every two years, Microsoft’s showing a clear commitment to supporting SQL Server now and in the future. Unfortunately, its support has limits and, recently, there are restrictions on SQL Server 2008 customers.

Four years ago, Microsoft announced that it would end its Mainstream support plan for SQL Server 2008. Since then, many SQL Server 2008 customers have continued to receive support through the Extended support plan, and they’ve paid a premium price for it.

Extended Support for SQL Server 2008 Is Ending

SQL Server 2008 may be celebrating its 10th birthday this year, but Microsoft plans to end the Extended support plan on which its customers rely. The company says it’s time for enterprises to upgrade to a newer, shinier, SQL Server version. Providing support for SQL Server 2008 may no longer be a profitable enterprise for Microsoft.

According to Microsoft, SQL Server 2008’s Extended Support plan disappears beginning on July 9, 2019.

SQL Server 2008 users don’t want to put their entire IT environment at risk, of course. An upgrade is in the cards if they want to avoid a ripple effect of ongoing problems. The newest Hyperion release, 11.1.2.4, is also the only version of Hyperion that officially supports newer SQL Server versions. For a quick glance at compatibility, take a look at our Hyperion Compatibility & Support Quick Reference Sheet .

You could upgrade SQL Server and forgo the recommended Hyperion upgrade, but Oracle support will also be limited for those who don’t upgrade. Many companies lean heavily on Oracle technical support to keep their system running smoothly. Without full access, they’ll only be able to download crucial patches and bug fixes.

Enterprises that remain attached to outdated legacy systems and applications like SQL Server 2008 will find their options dwindling. Even though the software has a history of stability and security, an upgrade to a newer version may be the smartest choice. To read more about the upcoming release of Hyperion 11.2, and compatibility concerns with SQL Server and Internet Explorer that will likely have you considering your upgrade sooner than later, read our latest white paper, The Clock is Ticking on Hyperion 11.2: Why You Need to Start Planning Now.

12c Upgrade Bug with SQL Tuning Advisor

This blog post outlines steps to take on Oracle upgrade 11.2 to 12.1 if you’re having performance problems. Oracle offers a patch and work around to BUG 20540751.

Megan Elphingstone | March 22, 2017

Oracle EPM Cloud Vs. On-Premises: What’s the Difference?

EPM applications help measure the business performance. This post will help you choose the best EPM solutions for your organization’s needs and objectives.

Bobby Ellis | April 10, 2018

Scripting Out the Logins, Server Role Assignments, and Server Permissions

Imagine there are over one hundred logins in the source server and you need to migrate them all over to the destination server. Wouldn’t it be awesome if we could automate the process by generating the scripts for the required tasks?

JP Chen | October 1, 2015

Work with Us

Let’s have a conversation about what you need to succeed and how we can help get you there.

CONTACT US

Work for Us

Where do you want to take your career? Explore exciting opportunities to join our team.

EXPLORE JOBS