After restoring a database from production to development, we often need to copy SQL Server logins too.  But how do we keep their passwords and their SIDs?

Toad does that. Connect to the source SQL Server in Toad and click the Migrate Security button in Connection Manager:

Migrate Security in Toad for SQL Server

The Migrate Security wizard starts and asks which logins you’d like to copy.  It gives you a script that you can copy/paste, or just tell Toad which server you’d like to run it against.  This works with SQL Server 2000, 2005, and 2008.

This entry was posted on Friday, November 13th, 2009 at 8:54 AM and is filed under Toad for SQL Server. You can follow any responses to this entry through the RSS 2.0 feed. Both comments and pings are currently closed.