0

I would like to know if Data Migration Assistant copies system databases (master, model, msdb) into the new server.

1
  • 1
    Why would it do ? system databases are created when you install sql server. So no need to copy. If you are referring to custom objects created in system database then migration assistant wont help you but dbatools will be able to copy that for you.
    – Kin Shah
    Aug 21, 2019 at 15:39

1 Answer 1

0

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:

For Azure SQL Database single databases and elastic pools, only master Database and tempdb Database apply.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.