SQL Compare®
Feature list
- Comparison and synchronization of SQL Server 2000, 2005 and 2008 database schemas, eliminating hours of tedious, error-prone manual work.
- Comparison and synchronization of live databases or snapshots
- Work directly with SQL script files under source control (Pro edition).
- Compare and deploy from backups, whether native SQL Server (2000 – 2008) or Red Gate SQL Backup, compressed and uncompressed formats (Pro edition).
- Deploy a live database from a set of object SQL scripts (Pro edition).
- Integrate with your source control system with SQL Changeset (Pro edition).
- 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.
- Support for reading encrypted database objects in SQL Server 2000, 2005 and 2008.
