bdseymou
asked on
Move SQL User Names
I am backing up and restoring databases from a SQL 2005 server to a SQL 2008 server and I read that I can use the sp_help_revlogin to migrate but I am wondering a few things. What do I change if I only wnat a specific database and how do I run this to get the output?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
The script captures all logins for a sql server instance and enables you to migrate them to another sql server instance.
Logins are defined at the server level - that script will not check if a login is for a particular database -but will copy all logins on the intance
Logins are defined at the server level - that script will not check if a login is for a particular database -but will copy all logins on the intance
for migrating loginds i am using this free tool from idera
http://www.idera.com/Products/Free-Tools/SQL-permissions/
hope it helps
http://www.idera.com/Products/Free-Tools/SQL-permissions/
hope it helps
ASKER