- Comparison and synchronisation of SQL 2000 and SQL Server 2005 database schemas, eliminating hours of tedious, error-prone manual work.
- Comparison and synchronisation 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 synchronisation script so databases can be perfectly synchronised.
- 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 synchronisation 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 synchronisation 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.
Some of the procedures SQL Compare will automate for you:
- Comparing two databases or a database with SQL scripts
- Generating synchronisation scripts
- Taking database snapshots and comparing them - useful for audit trails
- Change histories, ideal for database versioning
- Executing "right-first-time" database synchronisations
Standard Edition
Compares and synchronises SQL Server database schemas.
Pro Edition
Simpler automation and development with source control:
- Exports your database as set of script files.
- Compares/synchs with script files.
- SQL Changeset for integrated checkin/edit/checkout.
- Accesses command line interface.