SQL Examiner is an easy-to-use database comparison tool that quickly
and accurately compares and synchronizes schemas of SQL Server
databases, including stored in SQL Server 2008! With a few clicks of
the mouse, SQL Examiner merges selected databases and delivers exact
results by analyzing the dependencies between the objects and your data.
The tool’s flexibility allows you to be as involved as you want in the
development process, from step-by-step processing to full automation.
Due to the built-in Command Line tool, you can choose automatic,
one-click synchronization and focus on the main – design and
development. SQL Examiner handles all the routine work itself.
Features:
- Comparison:
- Microsoft SQL Server 7.0, 2000, 2005 and 2008 database comparison
- Live databases and snapshots as comparison source
- Database creation script as comparison source
- Detached database files and backups as comparison source
- Command Line Comparison and Synchronization tool
- Support for all schema objects, including tables, views, stored procedures, etc
- Support for SQL Server CLR objects, including assemblies, stored procedures, triggers, UDTs, UDFs
- Extended comparison options
- Support for column renaming
- Wide range of settings to cover your specific needs
- Synchronization:
- Partial synchronization
- "Smart" script-generating engine preventing a possible data loss
- Taking data in the target database into account
- Tracing links between objects within a schema
- Sophisticated script execution
