teodor76
asked on
transfer sql logins
I need to migrate a database from sql server 2000 to sql server 2008 so I backuped this database and then restored it to sql server 2008..now I need to transfer logins from sql server 2000 to sql server 2008 but to To my knowledge, Microsoft has not yet updated their Knowledge Base to inform administrators how to migrate SQL Server logins to SQL Server 2008..there is a article Method 2 of this Microsoft KB article details how to transfer a login from SQL 2000 to SQL 2005 but not sql server 2008..so how can I transfer sql logins from sql server 2000 to sql server 2008?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Alpesh Patel
Hi, you can do this using SSIS's Transfer Login Task. 