How to Update and Migrate from Sql Express 2012 to Sql Express 2019 on aus-possum.

Question

Hi Team,

Good Day!

We have got one request from our user that he need to Update and Migrate from Sql Express 2012 to Sql Express 2019 on aus-possum. Is it possible to do this? If yes means please provide the steps to do this.

Thanks & regards

Yogeshwar Balaraman

Answer 1

Sure it is possible to upgrade SQL Server 2012 to 2019 and it is fully supported, see

https://learn.microsoft.com/en-us/sql/database-engine/install-windows/supported-version-and-edition-upgrades-2019?view=sql-server-ver16

Download SQL Server 2019 Express, start the installer, select tab "Maintenace" => "Upgrade" and follow the installation wizard.

Before backup all system & user database to be on the safe side.

Answer 2

Hi @BALARAMAN,YOGESHWAR (Non-Agilent IND)

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

SQL Server 2019 (15.x) supports upgrade from the following versions of SQL Server:

• SQL Server 2012 (11.x) SP4 or later

Follow below steps:

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

Best regards,

Cosmog Hong

---

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".