SQL Examiner is an easy-to-use database comparison utility that quickly and accurately compares and synchronizes schemas of SQL Server databases, including stored in SQL Server 2009.

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.

Here are some key features of “SQL Examiner 2009″:

Comparison:
· Microsoft SQL Server 7.0, 2000, 2005 and 2008 database comparison.
· Live databases and snapshots as comparison source learn more.
· Database creation script as comparison source.
· Detached database files and backups as comparison source learn more.
· Command Line Comparison and Synchronization tool learn more.
· Support for all schema objects, including tables, views, stored procedures.
· 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 learn more.
· “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.

Requirements:

· .Net Framework 2.0
· MDAC 2.6

What’s New in This Release:

· The new version added an opportunity to compare and synchronize SQL Server databases with SQL scripts. Besides some minor improvements and bug fixes have been made.

Popularity: 1% [?]