Wednesday, June 6, 2012

Transfer logins between SQL Servers

We will keep on moving databases between instances, we migrate the databases from one server to another server, or we upgrade the sql versions. All the time we need to move logins from one server to another server. Here is the Microsoft KB article which generates login script, we can directly copy the script and paste it on target server. 

SP_HELP_REVLOGIN is the procedure we need to execute and copy the logins and execute on required server, automatically logins will transfer along with SIDs and passwords.

No comments: