Rod at work (9/5/2013)
We're finally moving to SQL 2012 from SQL 2005. Is there a way of automating the moving or copying of securables from the old database for some of the users, to the new database for the same users? If so, how is that done?
As "I.T.D." said, backup old DBs, then restore them to new server instance. If the server logins that relate to the DB Users exist on the destination when the restore takes place, the securables will align with those logins. Otherwise they will be orphaned. When the appropriate logins are added after the restore, they can be quickly fixed by use of
[font="Courier New"] sp_Change_Users_Login 'Auto_Fix', 'UserName'[/font]
Mike Hinds Lead Database Administrator1st Source BankMCP, MCTS