SQL Server Compare

SQL Server Compare is an easy-to-use tool to compare 2 SQL Server database schemas 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.SQL Server Compare is a database utility that compare two SQL servers.

SQL Server Compare 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.