SQL Compare box shot

SQL Compare®

Feature list

  • Comparison and synchronization of SQL 2000 and SQL Server 2005 database schemas, eliminating hours of tedious, error-prone manual work.
  • Comparison and synchronization of live databases, snapshots or SQL script files.
  • Deploy a live database from a set of object SQL scripts.
  • Integrate with your source control system with SQL Changeset.
  • Generate synchronization script so databases can be perfectly synchronized.
  • Support for all schema objects, including, but not limited to, tables, stored procedures, views, user-defined functions, XML schema collections, and CLR Assemblies.
  • Quickly produces comparison results and synchronization scripts.
  • Dependency checking so objects are scripted in the correct order for updates. Database objects are scripted in the correct order even if SQL metadata (sysdepends) is broken.
  • Provides warnings about anything you need to be aware of prior to running a SQL synchronization script.
  • Graphical comparison of differences in Microsoft SQL Server database schemas.
  • Save scripts for use later.
  • Save schema snapshots for audit and roll-back purposes.
  • Generate reports in HTML or Excel for an audit trail of database changes.
  • Offline comparison ability so you can compare disconnected databases.