Upgrade SQL 2012 SP 1 express to 2017 express

Rathod, Shashi 21 Reputation points
2021-01-22T07:07:09.797+00:00

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)

https://learn.microsoft.com/en-us/sql/database-engine/install-windows/supported-version-and-edition-upgrades-2017?view=sql-server-ver15#upgrades-from-earlier-versions-to-

It would be great help if anyone can suggest different ways to upgrade without loosing data.

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,899 questions
0 comments No comments
{count} votes

Accepted answer
  1. Shashank Singh 6,246 Reputation points
    2021-01-22T07:16:34.927+00:00

    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.

    1 person found this answer helpful.

1 additional answer

Sort by: Most helpful
  1. Olaf Helper 41,411 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