Microsoft announced that SQL Server 2008 and SQL Server 2008R2 are reaching the end of their extended support lifecycle in July, 2019. Microsoft’s blog contains more information regarding their support termination.
Due to the timing of Microsoft’s extended support termination, the CTT has determined that our support of the affected Microsoft products must end prior to our Spring 2019 software release. In response to this announcement, the CTT ended Roadsoft and MERL support for both SQL Server 2008 and SQL Server 2008R2 as of January 1, 2019.
After January 1, 2019, the creation of new Roadsoft and MERL databases will cease to function on SQL Server 2008 and SQL Server 2008R2. The 2019.3 release of Roadsoft will prompt customers to update if they connect to SQL Server 2008 products, and future Roadsoft releases will not allow connections to any of the SQL Server 2008 products.
The decision to discontinue support on SQL Server 2008 and SQL Server 2008R2 is a necessary step to ensure the safety of the systems that operate our software, and to retain the integrity of agency Roadsoft and MERL data.
Customers with existing databases on SQL Server 2008 and SQL Server 2008R2 (including full SQL Server and SQL Server Express) are encouraged to begin discussions with appropriate parties as soon as possible, particularly if an update or purchase of a newer version of SQL Server is necessary.
Customers using the CTT-provided SQL Server Express will have the opportunity to update their 2008 or 2008R2 SQL Express instances using a CTT-provided update installer. We will announce the update installer availability in the near future.
The CTT is continuing support for SQL Server versions: 2012, 2014, 2016, and 2017.
DETERMINING SQL SERVER VERSION
Help documentation for locating the SQL Server version is available in the Roadsoft Manual at Locate SQL Server Version.
Instructions on how to convert user data from SQL Server 2008 and SQL Server 2008R2 will be posted shortly.