I would like to know if Data Migration Assistant copies system databases (master, model, msdb) into the new server.
Sql-server – Does Data Migration Advisor migrate system databases
azure-sql-databasemigrationsql-server-2012sql-server-2016system-databases
Related Question
- Sql-server – Migrating system and user databases to a new server by moving the LUN
- Sql-server – Migrate data from MySQL to SQL Server, database names differ
- Sql-server – Migrate data from multiple disparate databases into 1
- Sql-server – How to Locate Resource System Database in MS SQL Server
- Sql-server – Migrate on-premise SQL Server databases to Azure SQL Database
- Only ‘master’ inside the system databases in Azure Managed instance
- Sql-server – Where Database Alerts & Operators Exist In SQL Server
Best Answer
No, because the Data Migration Assistant helps you to move from SQL Server to Azure SQL.
Azure SQL is a different product and thus the system databases are not the same. You will only be able to access the master database on your Azure SQL deployment. That being said, there really isn't anything you will be missing by not moving those over, since most functions of msdb aren't available on Azure SQL in the same way anyways.
From the documentation: