Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
leoc50
Yak Posting Veteran
54 Posts |
 Posted - 2014-05-01 : 19:01:15
|
| Hi All,A year ago my project was to discover and document "all" steps necessary to migrate side-by-side dbs from 2005 to 2008r2. Tis new company I am in with is doing a more aggressive approach (timewise) from 2008 to 2012.The issues I had then and still now is moving the login accounts. Initially it appeared that the 'copy' feature from 2012 was going to do the job but after quick tests it showed to be 'not productive'My question is what DBAs are using out there to accomplish the same task with these new versions? is MS sp_help_revlogin still a good solution even for version 2012 ? what about SSRS and SSIS?Thanks a lot in advanced!!!- lec |
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2014-05-02 : 01:37:46
|
| Hi , I've completed loads of migrations from sql server 2005\2008 to 2012 - all using sp_help_revlogin , which has the benefit of being scripted , so can be automated. Also , good for troubleshootingJack Vamvas--------------------http://www.sqlserver-dba.com |
 |
|
|
jeffw8713
Aged Yak Warrior
819 Posts |
Posted - 2014-05-05 : 14:04:44
|
| I will either use sp_help_revlogin - or a custom script I wrote that does the same thing. The key to sp_help_revlogin is creating the login with the same SID and password. That way you don't have to go through the process of using sp_change_users_login for every user in the database. |
|
|
|
|
|
|
Copying databases from 2008 to 2012 plus...