Any problems will occur during migrate SQL 2008R2 to SQL Server 2019?

Kit Chung 21 Reputation points
2022-07-14T13:06:48.127+00:00

I would like to upgrade SQL Server from 2008 R2 to 2019 but I don't know any potential problems will happen?

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,239 questions
0 comments No comments
{count} votes

Accepted answer
  1. Bjoern Peters 8,766 Reputation points
    2022-07-14T13:16:09.237+00:00

    Upgrade sounds like an inplace upgrade (better do a fresh install on a new machine)

    Inplace Upgrade => First problem for you will be... there is no direct upgrade path from 2008R2 to 2019... you have to do it in a two step upgrade process... SQL Server 2008R2 => SQL Server 2012 => SQL Server 2019
    https://learn.microsoft.com/en-us/sql/database-engine/install-windows/supported-version-and-edition-upgrades-2019?view=sql-server-ver16

    in preparation of that upgrade you might check your environment with Data Migration Assistant
    https://learn.microsoft.com/en-us/sql/database-engine/install-windows/prepare-for-upgrade-by-running-data-migration-assistant?view=sql-server-ver16

    It might be easier and better to just migrate the databases via Backup/Restore from that old system to freshly new installed SQL Server 2019, here you also can check everything before the migration with DMA.

    0 comments No comments

1 additional answer

Sort by: Most helpful
  1. Olaf Helper 38,786 Reputation points
    2022-07-14T13:32:15.367+00:00

    In common an SQL Server upgrade works well, but everything can happen.
    Ensure you have good backup and check your SQL Server installations + databases before using DMA:
    https://www.microsoft.com/en-us/download/details.aspx?id=53595

    0 comments No comments