SQL Server 2019 requires Windows Server 2016 or newer, so an in-place upgrade between 20 doesn’t become possible, because one of the two products would be operating on an unsupported operating system.
With SQL Server editions up to and including SQL Server 2017, supporting this operating system. SQL Server 2012 is only supported on Windows Server OS’ up to Windows Server 2012 R2. But it doesn’t take long to realise that in-place upgrades are likely not going to be possible for a lot of users anyway as they’re probably going to have to perform some level of migration efforts. But it is far more complex than running an installer and a guarantee all will be okay.įor example, Microsoft here have a process flow guidance chart, detailing common scenarios and whether or not in-place upgrade is supported. Maybe I over-simplified this point and created confusion, there are scenarios whereby in-place upgrades are supported for SQL Server by Microsoft. With that out of the way, lets start with installing the new SQL Server edition.
Sql server versions end of life install#
We’ll need to install the newer edition of SQL Server, either on a new server, or alongside your existing SQL Server instances, and then migrate the data across. In more words, you can’t perform an ‘in-place upgrade’. How can I upgrade my SQL Server instance? SQL Server 2022 is only in public preview, making it a poor candidate for production platforms at present. This is because SQL Server 2017, whilst still in mainstream support for now, enters extended support in October 2022, mere months away. Unless you are limited by the operating system support for SQL Server 2019, I don’t recommend going for anything older. Which version of SQL Server should I migrate to? I would also like to state that whilst this isn’t the focus of the article, if you’ve got a Veeam Backup & Replication or Veeam ONE environment that’s not running v11 yet, you really need to upgrade, as everything prior is at end of fix. This creates a security risk as of the next Microsoft patch cycle, scheduled for the 12th July 2022.
Sql server versions end of life update#
So, why am I talking about Veeam? If you’ve got an installation of Veeam that utilised a SQL Server Express database, and you installed Veeam prior to 9.5 Update 4, odds are you’ve got a SQL Server 2012 Express database. Not just to extended/security patch support, but completely out of support. On the 12th July 2022, Microsoft SQL Server 2012 will go End of Life. It’s that time of the IT lifecycle again, where we talk upgrades and decommissioning.
0 kommentar(er)
