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.
