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. 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 the Roadsoft 2019.9 release 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.
The CTT is continuing support for SQL Server versions: 2012, 2014, 2016, and 2017.
DETERMINE SQL SERVER VERSION, UPDATE, AND MIGRATE SERVERS
Help documentation for locating the SQL Server version is available in the Roadsoft Manual at Locate SQL Server Version.
Instructions on how to convert from SQL Server 2008 and SQL Server 2008R2 to a newer version can be found at Update SQL Server Express.
Instructions on how to migrate data from one server to another can be found at Back Up, Move, & Restore Database.