Well, the way that I always do it is to use the RedGate SQL Compare tool. www.red-gate.com. It works very nice and will compare everything, including permissions.
There are other ways, and Buck Woody (who I have seen around the forums) has an article here that covers it pretty well:
http://www.informit.com/guides/content.asp?g=sqlserver&seqNum=210&rl=1
|||You can use Visual Studio Team System(VSTS) for Database professional. It is covered all the features of readgate and something extra.|||I use the easiest/dumbest/cheapest way
Get SPs from both databases, and use free version of examdiff to compare them (or you can use Visual SourceSafe, etc..)
|||There are several free tools that do this. The one that I use is SQL Effects Clarity CE.
It compares tables, stored procedures, views, functions, users, roles, etc.
You can download it here: http://www.sqleffects.com/sfxClarityDetails.html
Hope this helps.
