by André Batista / Microsoft Delivery Manager (I.M.S.)
As you have probably heard SQL Server 2008 and SQL Server 2008 R2 will go out of extended support by Microsoft in July 2019. You should start preparing a plan in order to migrate all your SQL Servers with these versions to new ones, like SQL Server 2016 or SQL Server 2017. However, SQL Server 2019 is just around the corner and you may also wait for it to get released. Some of our customers, still run and maintain SQL Server 2008\R2. and here are the main reasons for that:
SQL Server 2008 is stable – As one old man said… ” if it’s good and running, please do not touch or change anything”…
Cost of upgrades\complexity – On some applications and infrastructure it can be a problem to migrate to new versions, and the effort you need to do it is not enough to just migrate your application.
Legacy and application compatibility – For the most part, when you are maintaining legacy software, you need not only to upgrade your databases, but also upgrade your Operating System and some other layers like Service Brokers or specific Middleware.
Lack of skills – Some business lack in-house knowledge and don’t even try to find a solution since … everything is working!
Main risks if you still choose to be on an unsupported version:
Compliance – Nowadays, more companies focus on industry standards and regulations regarding security. With the GDPR and PCI DSS in place, the organization requires to be running and use supported platforms. Non-compliance organizations may have legal or financial problems in the business.
Security – Once SQL Server 2008 and SQL Server 2008 R2 move out of extended support, they will no longer receive security updates. This is pretty bad since you will be exposed to cyber attacks or even ransomware exploits.
Unable to use new features – Like the security updates, Microsoft will no longer release any kind of new feature releases or fix problems identified on the database engine, or on any other component of the Data Platform.
We at Crossjoin Solutions can help you achieve a smooth database migration, making sure that your application still works after the upgrade or even set up a temporary High Availability infrastructure in order to ensure the minimum downtime for your customers.