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

Kit Chung 21 Reputation points

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

    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

    in preparation of that upgrade you might check your environment with Data Migration Assistant

    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

    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:

    0 comments No comments