What's New
Datanamic SchemaDiff for MS SQL 2011 provides a more efficient way to compare and synchronize your database schemas, with improved synchronization script generation, a new differences viewer, and comparison options to let you tweak the way the comparison works. A new command line utility has been included. With that utility you can perform unattended schema synchronization. This new version also adds support for MS SQL 2008.SQL Script To Database Schema Comparison
Instead of a live database, you can now also load a SQL script for your source or destination database. Datanamic SchemaDiff will load all objects defined in the DDL file and will treat it as a normal database.
Datanamic SchemaDiff for MS SQL now has compare and synchronize functionality for all synchronization use cases: database-to-database, database-to-script, script-to-database and script-to-script.
New Comparison Options
More than 30 comparison options have been added. You can use the comparison options to define how and what will be compared. You can for example specify to ignore names of check constraints or to autoformat the code of views for better comparison results.
Options include: ignore descriptions, ignore constraints, do not compare comments in views, procedures, triggers, ignore constraint names, autoformat view code, ignore empty lines in code, ignore specific object type (views, triggers etc), case insensitive comparison, etc...
Improved Object Differences Panel
Differences panel displays, side by side, the SQL scripts of the compared objects. The differences between the objects are highlighted using a simple color coding scheme. From now on, renamed elements (for example renamed columns) are detected and correctly displayed side by side. The new version uses a smarter routine to determine in which order the elements must be displayed. This results in less empty lines.
New Command Line Utility
With the new command line utility you can perform unattended schema synchronization. You create a project with the GUI version and run that project with the command line utility. With the command line utility you can compare, synchronize and create a differences report.
Extended Database Support
MS SQL database support has been extended with support for MS SQL 2008. MS SQL 2008 R2 is also supported. We also added support for comparing index options and column options.Improved Synchronization
We added synchronization options enabling you to ignore certain elements (for example ignore characters sets etc).
The new synchronization script generator fixes some object dependencies issues and generates more reliable synchronization scripts.
Redesigned Differences Report
Export all comparison results or a selection of differences to a differences report (HTML). The new report includes several improvements such as improved wrapping of long lines.Improved Schema Mappings
From now on you can define your schema mappings in the Compare dialog. Schema mappings are now also displayed in the difference details panel.See also: Complete version history.
