Yes that is correct to upgrade from SQL Server 2012 to SQL Server 2017 the SQL Server should be on Service Pack 2(Sp2) "at least" to allow it for in-place upgrade. If you ask me, since you have SP1, I would suggest you to upgrade to Sp4 and then migrate. This would just fix any bugs at all which you might face.
Upgrade SQL 2012 SP 1 express to 2017 express
Hi Team,
We have a requirement to upgrade SQL 2012 SP 1 express to 2017 express edition on multiple machines.
These machines holds Configuration & Transaction Data stored in 2 Databases on each machine.
I have gone through few links which states that SQL 2012 SP 2 express or higher can ONLY be upgraded to 2017 express (refer link below)
It would be great help if anyone can suggest different ways to upgrade without loosing data.
SQL Server
1 additional answer
Sort by: Most helpful
-
Olaf Helper 47,416 Reputation points
2021-02-01T14:47:27.523+00:00 Hello,
The Express Edition is free for use, even in a commercial environment, see Microsoft® SQL Server® Express License Terms for Redistribution and Hosting