What's New
Datanamic SchemaDiff for PostgreSQL 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 pre-format 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 Differences Panel
Differences panel displays, side by side, the SQL definition 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
We created a command line utility that enables you to compare and synchronize the schemas of PostgreSQL databases with 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.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 the comparison results 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.
