What's New
Datanamic SchemaDiff MultiDB 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. We also included a command line utility so that you can perform unattended schema synchronization.Load Database Schema From SQL Script
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.
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.
Automate With New Command Line Utility
We included a command line utility that enables you to compare and synchronize the schemas of databases via the command line. Create a comparison project with the GUI version. Run that project using the command line utility.
Extended Database Support
PostgreSQL database support has been extended with support for PostgreSQL 8.3 and 9. For MS SQL Server, support for MS SQL 2008 has been added.From now on you can also compare and synchronize MS Access databases (versions 2000, 2003, 2007 and 2010).
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 smaller and 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.
