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

BALARAMAN,YOGESHWAR (Non-Agilent IND) 0 Reputation points
2024-04-26T02:30:24.6133333+00:00

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

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,759 questions

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Olaf Helper 40,901 Reputation points
    2024-04-26T05:37:17.37+00:00

    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.

    0 comments
  2. CosmogHong-MSFT 23,321 Reputation points Microsoft Vendor
    2024-04-26T06:00:54.91+00:00

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

    0 comments