We have a single SQL server with about 60 databases running on Win2012r2 with SQL 2014.
I am in the process of planning a hardware refresh and plan to migrate to WIN2016 with SQL 2017, I understand the basics of migrating to a new server (copy files over, re-attach, test etc).
My question is, we have specific restricted logins setup for each database. The logins are windows ad groups and have specific permissions for their allowed databases. In addition to this we have about 20 SQL logins with the same setup against their databases.
My question is, how can i migrate these logins and databases while maintaining the permissions for specific databases?