xSQL Schema Compare is a software that allows for easy comparison and synchronization of SQL Server database schemas. It is compatible with all editions of SQL Server 2005, 2008, and 2012, and is free for users of SQL Server Express.

This software offers a range of helpful features including full support for SQL Server 2012, SQL Server 2008, and SQL Server 2005 - all objects. It also supports cross-version comparison, allowing you to compare databases on different SQL Server versions and generate version-specific change scripts.
The software includes schema snapshots. These snapshots maintain a history or audit trail of the schema changes made, which is highly beneficial in reversing schema changes when necessary. The wide array of options provided allows for granular control of the behavior of the comparison engine.
Comparison results are displayed in an easy-to-read color-coded grid that allows you to drill down into differences, view the scripts of objects, filter results, and more. You can also generate safe, standardized change scripts and review scripts before executing on the target database.
The command-line utility provides for scheduled, unattended comparison and synchronization operations. With all these exceptional features, xSQL Schema Compare for SQL Server is undoubtedly the ideal tool for SQL Server developers and database administrators looking for reliable software to automate their database schema synchronization process.
Version 4.0.0.0: Added support for SQL Server 2012; new interface; new comparison engine
Version 3.0.0.0: Added support for SQL Server 2008
Version 2.5.2.7:
- added command line utility
- added comparison wizards
- added comparison sessions
- added script encoding
- added comparing and synchronizing databases with different file group structures
- added object counts
- enhanced support for bulk inserts