Monday, April 18, 2011

Is Your EnterpriseOne SQL Database Version Current and Supported?

Underlying every EnterpriseOne system is a database.  Technically a Relational Database Management System (RDBMS), most simply refer to it as 'the database'.  The database sitting under E1 is either Microsoft SQL Server, Oracle database, or IBM DB2 and just as EnterpriseOne must be kept up to date, so too must the database software.

Oracle's Minimum Technical Requirements (MTR's) specify certain versions and editions for EnterpriseOne databases.  Oracle's support (or lack of support) for a version is driven by their policy on 3rd party software which states: "The general JD Edwards EnterpriseOne support policy is to withdraw support for a platform component when the vendor withdraws its primary or mainstream support." (EnterpriseOne Statement of Direction)This means that when Microsoft stops supporting a certain version of SQL Server in its Mainstream Support, Oracle may stop supporting that version for EnterpriseOne...and most likely will.

Information about Microsoft's current (and importantly, future) support levels for all SQL Server versions and editions can be found in the Microsoft Product Lifecycle Search.  For example, you can see in the results table that support for SQL 2000 ended in April 2008 as did support for SQL 2005 SP1.  Consequently, Oracle no longer supports those database versions for EnterpriseOne.  Also you may notice that Microsoft no longer offers Mainstream Support for SQL Server 2005.  This means that Oracle's support for SQL 2005 as an EnterpriseOne database is at an end.

Support for SQL 2008 SP1 will end in October 2011.

As of early October 2011, the only SQL Server database version that will be supported for EnterpriseOne is SQL 2008 SP2 (and 2008 R2).

To find out if you are on a version of SQL Server that is supported, first determine your exact SQL Server version and edition by running the following SQL script:

--SQL Script Begin
SELECT SERVERPROPERTY('productversion') AS "Version Number",
SERVERPROPERTY ('productlevel') AS "Product Level",
SERVERPROPERTY ('edition') AS Edition
--SQL Script End

The results should look something like this:

Version Number Product Level Edition
10.0.2789.0SP1 Standard Edition (64-bit)

The version number correlation is as follows:

7.00 = SQL Server 7.0
8.00 = SQL Server 2000
9.00 = SQL Server 2005
10.00 = SQL Server 2008
10.50 = SQL Server 2008 R2

To find the exact version from the version number you can look in the SQL Server Version Database.  Once you know the exact version, use Oracle's Minimum Technical Requirements then the Microsoft Product Lifecycle Search to determine Microsoft's future support end dates.

If your SQL Server version is lower than SQL 2008, you are not currently supported by Oracle with EnterpriseOne.  Lower than SQL 2008 SP2 and you will not be supported come October.

The fact is that it's time to move to SQL Server 2008 R2 to ensure support for your EnterpriseOne system.  Besides simply ensuring support from Oracle, it is best to improve your system stability and performance by utilizing the most current code possible.  Microsoft is continually updating bugs and adding features to SQL Server and every new version is faster than the old one.

The Karamazov Group offers a complete SQL Server upgrade package, including project planning, project management and a minimal downtime cutover.  We have over 11 years of EnterpriseOne SQL Server expertise and have already completed multiple flawless SQL Server upgrades.  Contact us to discuss your SQL Server Upgrade.
Subscribe to The Karamazov Group Blog - Get an email when new posts appear

No comments: