this is another nifty tool for web programmers and dba’s. its free and it will compare tables, stored procedures, indexes, triggers, users, etc. between two databases (servers too). it’s especially helpful when you develop something in a local environment then need to replicate your changes to a testing environment and then push them to a production environment.
because the author doesn’t seem to list a homepage i’m archiving this gem on my server… you can download it here >> SQLServerCompare.exe