Click here to monitor SSC

SQL DB copy & security update tool?

Last post 05-06-2009, 12:04 AM by Rusty. 0 replies.
Sort Posts: Previous Next
  •  05-06-2009, 12:04 AM Post number 73359

    • Rusty is not online. Last active: 05-06-2009, 12:27 AM Rusty
    • Top 500 Contributor
    • Joined on 10-26-2007
    • Level 1: Deep thought

    SQL DB copy & security update tool?

    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

     

View as RSS news feed in XML