Upgrade SQL 2012 SP 1 express to 2017 express

Rathod, Shashi 21 Reputation points

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
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

    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


    The Express Edition is free for use, even in a commercial environment, see Microsoft® SQL Server® Express License Terms for Redistribution and Hosting