SQL Server Compare

SQL Server Compare is an easy-to-use tool that compares 2 SQL Server database schemas and list differences.
Compares tables, stored procedures, indexes, triggers, users, views and record counts.
You can view or save SQL scripts of differing objects.