Hi Everyone,
I'm working at a small SQL shop where we copy over several of our production databases to a development server for the developers and testing. We're moving the databases by restoring the nightly backups, however the database logins on the dev database have to be added by a small T-SQL script. Since I'm the junior DBA I always have to update the script when we add or remove users from the dev team. I'm wondering if there's a tool/utility out there the might automate this process?
I'm guessing this is a good job for powershell, but I'm lazy and would rather buy a tool than build something I would need to maintain.
Thanks!
Russ