I'm currently working on a SQL Server migration (from a SQL Server 2005 to a 2008 R2 server, on a new physical server).
The databases themselves will be transferred using a database backup and restore script. I have tested this fine and it works without problems.
My worry is rather regarding all the other instance/system objects, like Logins, SQL Agent jobs. These have been scripted out from the source server and reapplied on the new server, and I'm afraid I have forgot some. I can obviously visually compare using SQL Management Studio, which is what I did, but it is time-consuming and error-prone. So, before plugging the plug off the existing server in due time, I would prefer to have a more "scientific" way to confirm that everything is in there...
I've looked for software doing this kind of comparison and have found only schema or data compare tools. I guess I could compare the system tables like sys.sql_logins and msdb.dbo.sysjobs, etc, but I don't know them all.
In short, is there a way to quickly compare the instance-level objects of two servers, and if possible, their contents as well rather than just by name?