Migrate your Microsoft SQL Server environment with DBA.nl! Migrating a database environment is not one of the most popular IT projects. Some organizations can’t wait to get started with the latest version of Microsoft SQL Server. But most of the users want to wait as long as possible with the upgrade. After all, if it ain’t broke, don’t fix it. Questions that are asked are for example: “Are my applications compatible with the latest version?” and “Is my hardware still sufficient?”. The answers to these questions are the starting point for a good migration.
Microsoft supports its products for a certain period of time. This one is called “Support Life Cycle”. Depending on the product, this period varies from 18 months to several years. Support on Microsoft SQL Server 2008 ended in July 2019. The next version that is no longer supported is SQL Server 2012. Support for this will end in July 2022. This means that you now have to think about the upgrade to a new version. The importance of a new version is therefore great. Because, first of all, if the mainstream support expires, it means that Microsoft is no longer improving the product. Secondly, no warranty can be claimed anymore. Finally, no more hotfixes (security updates) will be released after extended support. In addition to hotfixes, bug fixes and other important patches will expire after extended support. In short, your SQL Server is outdated with all the dangers that come with it!
What can you do to keep a safe environment? The answer is obvious. Upgrade to the latest version of Microsoft SQL Server. If your applications do not (yet) support this, you can always look at SQL Server 2017 or 2016.
The consultants of DBA.nl can advise you on this. By migrating to a newer or the latest version, you know that your SQL environment will be supported again for quite some time. For example, the extended support on SQL Server 2019 runs until August 1, 2030.
As can be seen in the overview below, the end of extended support for SQL Server 2012 is approaching and the end of support for 2012 and 2014 is also in sight. An overview of all updates can be found here, on the Microsoft website.
|release||Support end date||Extended Support end date|
|SQL Server 2019||July 1, 2025||August 1, 2030|
|SQL Server 2017||October 11, 2022||October 12, 2027|
|SQL Server 2016||July 13, 2021*||July 14, 2024|
|SQL Server 2014||July 9, 2019*||July 9, 2024|
|SQL Server 2012||11 July 2017*||July 12, 2022|
|SQL Server 2008 R2*||July 8, 2014*||July 9, 2019*|
*Support has expired
“Thank you for the report! It was amazing to have you on board for these 2 days!
Thank you for all your input!”
– Dimitrios – DDL
In addition to an on-premise upgrade, another option is to migrate your environment to the cloud. This is also an interesting scenario for different environments. However, there is a fundamental difference between SQL Server and Azure SQL. Namely, in SQL Server, databases are the only entity on the database server. In contrast, in SQL Azure, a single database can host databases from different customers. In other words, Azure SQL is multi-tenant and therefore shares its physical resources with all clients that use this service.
Some other advantages of Azure SQL are firstly the management and administration is relatively easy. Second, High availability, this is guaranteed because Azure is known for it. Third, Azure SQL is easily scalable
DBA.nl supports you in migrating your SQL Server environment. A migration process at DBA.nl looks like this: the first contact is with the account manager and a senior DBA person. After this meeting, an estimate of hours will be made for your migration. You will also receive a planning and a quotation for the migration of the environment. After approval of this quotation, the project will be carried out by one of our experienced DBA staff. The advantage of having the migration performed by our experts is that the SQL Server settings are immediately optimized for your specific situation. So your environment directly meets your needs.
In addition to highly experienced DBA staff, DBA.nl also employs professional project leaders. They take care of the project out of your hands. This leaves you more time for your own work and, finally, you are guaranteed a good result.
A migration of your Microsoft SQL Server environment is possible from 89 euros per hour.
Do you have a question or comment? Leave your details. We will contact you as soon as possible.