Post reply

SQL Server 2022 Restore and DBCompat

  • March 17, 2023 at 12:00 am

    #4147676

    Comments posted to this topic are about the item SQL Server 2022 Restore and DBCompat

  • March 17, 2023 at 5:59 am

    #4161762

    Crud... I knew the answer but clicked on the wrong bloody button. 🙁

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

  • March 17, 2023 at 7:15 am

    #4161796

    answer in my opinion is incorrect (or question badly formed) - see https://learn.microsoft.com/en-us/sql/database-engine/install-windows/supported-version-and-edition-upgrades-2022?view=sql-server-ver16, Migrate to SQL Server 2022 (16.x).

    one thing is the "from" the other is the "after"

  • March 17, 2023 at 7:59 am

    #4161811

    I agree with Frederico.  This

    Databases with a compatibility level of 90, including backups taken on SQL Server 2005 (9.x), are automatically upgraded to a compatibility level of 100 when restored to SQL Server 2022 (16.x).

    suggests that you can restore a SQL Server 2005 backup and with compatibility level of 90. However, you won't end up with a compatibility level of 90 even if you can start with one.

    On two occasions I have been asked, "Pray, Mr. Babbage, if you put into the machine wrong figures, will the right answers come out?" ... I am not able rightly to apprehend the kind of confusion of ideas that could provoke such a question.
    —Charles Babbage, Passages from the Life of a Philosopher

    How to post a question to get the most help http://www.sqlservercentral.com/articles/Best+Practices/61537

  • March 17, 2023 at 2:04 pm

    #4161973

    Migrate to SQL Server 2022 (16.x)

    You can migrate databases from older versions of SQL Server to SQL Server 2022 (16.x), as long as the source database compatibility level is 90 or higher. Databases with a compatibility level of 90 (for example, on SQL Server 2005 (9.x)), are automatically upgraded to a compatibility level of 100 when migrated to SQL Server 2022 (16.x). If the compatibility level on the source database is 100 or higher, it will be unchanged on SQL Server 2022 (16.x).

    --------------------------------------
    ;-)“Everything has beauty, but not everyone sees it.” ― Confucius

  • March 20, 2023 at 4:46 pm

    #4162940

    I can reword the question. I was getting to the point that while you can restore a SQL 2005 backup, you will not get compat level 90. This will get changed.

Viewing 6 posts - 1 through 5 (of 5 total)

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