I am using DMA with the intention to assess and migrate everything from an onprem sql server 2016 into an onprem sql server 2019.
It looks like DMA only allows migration of:
- User databases, users and permissions (example: grants, revokes, denys)
- Server logins, roles, custom roles and permissions
It does not migrate:
- Ssis db and packages
- Maintenance plans
- Linked server configs
- Server level configs
- Db level configs
- System dbs
What else am I missing in the list?
I would say everything else that is not inside a user database: certificates, endpoint, AG configurations, server audit and so on.
It’s difficult to do a list. Every feature at server level is not cloned.