question

matteu31400 avatar image
0 Votes"
matteu31400 asked matteu31400 answered

migration sql express 2012 to 2019 cu 14

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-general
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Cathyji-msft avatar image
0 Votes"
Cathyji-msft answered

Hi @matteu31400,

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.



5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

matteu31400 avatar image
0 Votes"
matteu31400 answered

Oh you're right !

Thanks :)

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.