migrate users from 2008 to 2012

  • mstephens1754

    SSCommitted

    Points: 1650

    I have seen scripts that will migrate all users from one sql server to another. My question is how do I migrate certain user accounts not all?

  • tripleAxe

    SSCertifiable

    Points: 5605

    Depends on how many users you are talking about. I've used sp_help_rev_login and reviewed the output script to select the users I was interested in. For one or two users I've scripted the logins from Management Studio.

    This KB article has the code for the sp_help_rev_login stored procedure - http://support.microsoft.com/kb/918992

    For SQL Server Logins remember to map the database user to a login afterwards. I've used sp_change_users_login in the past but see that Microsoft recommend using ALTER USER instead now.

    http://technet.microsoft.com/en-us/library/ms174378.aspx

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply