upgrade path to SQL 2019

  • I read the upgrade path for standard edition to SQL server 2019, the oldest version is SQL server 2012 SP4.  If earlier than 2012 it may need a version of middle to upgrade first, then to 2019.

    If this is s side by side installation and upgrade, like to a new server with SQL sever 2019 installed, when we restore a version of database that is before 2012 SP4 to the new server 2019, what will that happen, will the database be upgraded?

    Thanks

  • Thanks for posting your issue and hopefully someone will answer soon.

    This is an automated bump to increase visibility of your question.

  • For the restore operation, according to the documentation, you can go as far back as a 2005 backup and restore it to 2019. As to the in-place server upgrades, you've already got the documentation. After the restore, your database will be in an older compatibility mode. This will keep some operations working as they used to while you test the upgrade. After the tests are successful, you can change the compatibility mode and get all the benefits of the upgrade (and possibly hit some problems, especially with cardinality estimation). I strongly recommend you take advantage of Query Store as a tool during your upgrade processes. I have a blog post about it here.

    That's about it. Strong recommendation, plan for an extended testing period if you're upgrading from 2012 or less to greater than 2014. When 2014 introduced the new cardinality estimation engine, some queries on some systems suffered quite a lot. That's mostly likely to be the source of any serious problems. Although, you may hit issues anywhere along the way. It's hard to know for certain with tons more information about your systems.

    ----------------------------------------------------
    The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood...
    Theodore Roosevelt

    The Scary DBA
    Author of: SQL Server 2017 Query Performance Tuning, 5th Edition and SQL Server Execution Plans, 3rd Edition
    Product Evangelist for Red Gate Software

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply