Features
| Learn more |
|
Feature list
How does it work? |
| Walk-through |
| Introductory walk-through |
Supports comparison and synchronization for MS SQL Server, Oracle, MySQL, InterBase, Firebird and PostgreSQL databases.
Compare database schemas
Compares tables, indexes, columns, constraints, views, procedures, functions, sequences/generators and domains.
Synchronize database schemas
Generates accurate and database specific SQL scripts for synchronization.
Visual representation of differences between two databases
A side-by-side, colour-coded comparison overview makes it easy to pinpoint at a glance similarities and differences between two database objects.
Summary of differences between two databases
Compare difference summary includes objects in source but not in destination (or vice versa), identical objects and the totals of selected objects.
Map schemas/owners in source and destination database
Mapping schemas enables you to compare database objects that belong to the same or different schemas.
Generate HTML reports with database differences
You can create HTML reports on database schema comparisons for archiving, distribution or export to other applications. A differences report can include all objects or only non identical objects.
Cross database version comparison and synchronization
The databases you want to compare do not have to be of the same version (for example MS SQL Server 2000 and MS SQL Server 2005, Oracle 10 and Oracle 11). DB Schema Difftective generates standardized, version specific synchronization scripts.
Synchronize whole database or selected objects
You can select the database objects you want to synchronize.
Handles object dependencies
DB Schema Difftective handles referential integrity and database object dependencies so objects are synchronized in the correct order.
Comparison results filtering
Filtering the comparison results enable you to limit the display of objects to certain types of database objects (for example, show only tables and/or views). Next to the object type filters, DB Schema Difftective has filters for the status of an object (identical, differs etc).
