SQL system database move

DavidKernaghan-6299 20 Reputation points
2023-05-25T13:12:09.8066667+00:00

We are upgrading our SQL and Server OS from 2012 to 2019; SQL 2012 to SQL 2019 and Server 2012 R2 to Server 2019.

I need to know how I can move/migrate/rebuild the system databases from the SQL 2012 instance to the SQL 2019 instance.

I know that you can't restore a system DB from an older version of SQL to a newer one, but I'm also on seeing ways that you can move the data (or such) into the new SQL instance on some websites:

https://learn.microsoft.com/en-us/sql/relational-databases/backup-restore/restore-the-master-database-transact-sql?view=sql-server-ver16

Any assistance would be appreciated.

Thanks

D

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,310 questions
{count} votes

2 answers

Sort by: Most helpful
  1. Tushar Kumar 3,311 Reputation points MVP
    2023-05-25T13:34:14.6133333+00:00

    Your best bet will be using DMA (https://www.microsoft.com/download/details.aspx?id=53595).

    This will help you assess your database for Upgrade compatiblity and flag all the breaking changes in the database. Once you feel comfortable with the changes(if any) you can use the same to migrate the Database to Newer SQl version.

    Refer the following : https://learn.microsoft.com/en-us/sql/sql-server/migrate/guides/sql-server-to-sql-server-upgrade-guide?view=sql-server-ver16

    Please accept as Answer if this helps :)


  2. PercyTang-MSFT 12,426 Reputation points Microsoft Vendor
    2023-05-26T07:23:24.7466667+00:00