February 22, 2023 at 1:52 pm
Hello,
I would like to upgrade my SQL Server 2012 Express instance (10.0.2100) to 2019 Express, but during the verification checks, I receive an error stating that Service Pack 2 is required to proceed.
The issue is that I cannot find any SP2 for Express. Do I need to use the standard version instead?
thank you
February 22, 2023 at 3:12 pm
Just want to verify you are on SQL 2012 and not SQL 2008?
Should 10.0.2100 actually be 11.0.2100?
Major version 10 is SQL 2008 so wont go to 2019 without an intermediary version upgrade.
But I cannot see a 10.0.2100 in the build list, so I am going to assume that was a typo and was actually meant to be 11.0.2100.
https://sqlserverbuilds.blogspot.com/
It doesn't matter if your Express/Wed/Standard/Enterprise the service pack is still the same, so you just search for "SQL Server 2012 Service Pack 2" and it will be the right service pack.
https://www.microsoft.com/en-us/download/details.aspx?id=43340
Although realistically you want to install Service Pack 4
https://www.microsoft.com/en-us/download/details.aspx?id=56040
As if you check the documentation
Upgrades from earlier versions to SQL Server 2019 (15.x)
SQL Server 2019 (15.x) supports upgrade from the following versions of SQL Server:
SQL Server 2012 (11.x) SP4 or later
SQL Server 2014 (12.x) SP2 or later
SQL Server 2016 (13.x) RTM or later
SQL Server 2017 (14.x)
February 27, 2023 at 5:48 am
This was removed by the editor as SPAM
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply