Post reply

migrate users from 2008 to 2012

  • January 8, 2014 at 12:34 pm

    #284251

    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?

  • January 9, 2014 at 2:05 am

    #1678700

    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 1 (of 1 total)

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