SQL Server Compare

SQL Server Compare is an easy-to-use tool to compare 2 SQL Server database schemas and show or save the list of differences. The program can Compare Database tables, stored procedures, indexes, users, triggers, views and record counts and SQL scripts of different objects can be viewed and saved. Databases can be located on separate servers, using integrated Windows security or SQL server login. The program does not change the database in any way, and it can not execute any SQL Statements - it only compares the schema. Requires SQL server or client installed.