Been a while since I posted but here I am!
I recently needed to copy SQL users from one DB to another without changing SIDs etc, while googling how best to do this a colleague just told me to use dbatools.
Well I’m glad I did, they are amazing! If you’re not sure what dbatools is, its PowerShell for SQL!!
Here’s what I did:
Install the tools on my device:
Install-Module dbatools -Scope CurrentUser
Then I simply ran:
Copy-DbaLogin -Source SourceDB -Destination DestDB -force
and thats it.