how to update SQL server 2012 to 2019

Jeremy Lopez 0 Reputation points
2023-02-01T16:02:53.5866667+00:00

How do you update from old SQL server 2012 to 2019 without losing 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.
13,214 questions
SQL Server Migration Assistant
SQL Server Migration Assistant
A Microsoft tool designed to automate database migration to SQL Server from Access, DB2, MySQL, Oracle, and SAP ASE.
507 questions

5 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. LiHongMSFT-4306 25,326 Reputation points
    2023-02-02T03:23:57.54+00:00

    Hi @Jeremy Lopez

    Pre-upgrade checklist

    • Before upgrading from one edition of SQL Server 2019 (15.x) to another, verify that the functionality you're currently using is supported in the edition to which you're moving.
    • Verify supported hardware and software.
    • Before upgrading SQL Server, enable Windows Authentication for SQL Server Agent and verify the default configuration, that the SQL Server Agent service account is a member of the SQL Server sysadmin group.
    • To upgrade to SQL Server 2019 (15.x), you must be running a supported operating system. For more information, see Hardware and Software Requirements for Installing SQL Server.
    • Upgrade will be blocked if there's a pending restart.
    • Upgrade will be blocked if the Windows Installer service isn't running.

    Refer to this doc for more details: Supported version and edition upgrades (SQL Server 2019)

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

    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.

    1 person found this answer helpful.
    0 comments
  2. Bruce (SqlWork.com) 60,386 Reputation points
    2023-02-01T16:08:30.53+00:00

    When you install 2019, pick update existing instance. You should be sure to backup the databases first in case of any issues.

    0 comments
  3. Erland Sommarskog 105.8K Reputation points MVP
    2023-02-01T22:50:47.23+00:00

    Do as Bruce says, or install a new instance and move databases with BACKUP/RESTORE. Many people do the latter, as they move to new hardware at the same time as the upgrade.

    0 comments
  4. Olaf Helper 42,841 Reputation points
    2023-02-02T06:44:20.6766667+00:00

    SQL Server 2012 => 2019 isn't a simple update, it's a version upgrade and why do you think, you could lose data?

    See Upgrade SQL Server for more details.

    0 comments
  5. Muhammad Kamran 0 Reputation points
    2024-02-07T16:18:22.6466667+00:00

    There is no loss of data for upgrade. you will need to confirm that the upgraded version support your current SQL version. Check the following article to upgrade from SQL 2012 to 2019, all the prerequisites and steps are mentioned in simple manner. https://www.dbsection.com/how-to-upgrade-sqlserver-2012-to-2019/

    0 comments