-3

I have restored one db of one instance from uat to anthother dev instance of the same server but how to fix orphan users I got 106 users how to fix and how to create logins is there any script for this scenario

Shanky
  • 18,985
  • 4
  • 35
  • 58
nasar
  • 37
  • 3

1 Answers1

1

I've started using Powershell and dbatools - you can copy and migrate all kinds of sql objects (copying logins is super easy) - see this link - https://dbatools.io/getting-started/

Scott Hodgin - Retired
  • 23,854
  • 2
  • 26
  • 48