I'm in the process of moving from SQL 2005 to SQL 2008 R2. Moving the production DBs and logs is straightforward, through either detach/attach or backup/restore. (new hardware, so I have the old system running in parallel with the new one during the move)
I'm wondering about the system DBs, though (master & msdb). What's the best way to move their key contents over, retaining as much old-system data as I can, including logins, users, account passwords and so on? (I know I can't just do a backup/restore).
No clusters, mirrors, replication, linked servers or SSIS involved. There are some standard maintenance jobs.
Is running the scripts created using Tasks --> Generate Scripts enough? Are there parts of the generated scripts that aren't portable from SQL 2005 to 2008 R2?
After getting the system DBs moved, are there other steps I should take to complete the migration and avoid things like orphaned logins? Are there old-system settings that I need to set manually?