migration sql express 2012 to 2019 cu 14

matteu31 467 Reputation points
2021-11-05T11:39:30.147+00:00

Hello,

I would like to know how it's possible to do the migration.
I have sql 2012 express installed on my server and the only way I find to migrate to 2019 cu14 is to do it with 2 step :

2012 -> 2019
2019 -> 2019 cu14

The 2019cu14 installation file doesn't work to upgrade from 2012.

How is it possible to do the migration in 1 step ?

Thanks

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,641 questions
0 comments
Accepted answer
  1. CathyJi-MSFT 21,081 Reputation points Microsoft Vendor
    2021-11-08T03:16:02.913+00:00

    Hi @matteu31 ,

    >migration sql express 2012 to 2019 cu 14

    SQL 2019 do not have CU14, the latest CU for SQL 2019 is CU13.

    >How is it possible to do the migration in 1 step ?

    The answer is NO. It is impossible to do that.

    You need to follow below steps to upgrade SQL 2012 Express to SQL 2019 CU13 Express.

    1. Apply SP4 for SQL server 2012 Express.
    2. Upgrade SQL 2012 SP4 Express to SQL server 2019 Express.
    3. Apply the latest CU13 for SQL server 2019 Express.

    Quote from MS document Supported version & edition upgrades (SQL Server 2019).

    147223-screenshot-2021-11-08-111159.jpg

    If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    0 comments

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. matteu31 467 Reputation points
    2021-11-08T08:40:48.477+00:00

    Oh you're right !

    Thanks :)

    0 comments