How do I transfer users and permissions over?
I can't seem to find any information on this through searches so I hoping someone has already resolved this. I have SQL Compare and SQL Data Compare, but I cannot seem to get the user permissions to copy. I can copy the logins and database users (with default passwords). How do I get the roles and permissions to come across as well? Thank you for your patience if this is a newbie question.