Perform Database Object Comparisons and Synchronizations
DB Schema Difftective is a tool for comparison and synchronization of database schemas. It allows you to compare and synchronize tables, views, functions, sequences (generators), stored procedures, triggers and constraints between two databases.
DB Schema Difftective will give you the full picture of all database differences. Once your databases are compared, you can view the differences and generate the necessary (database specific) synchronization script to update the destination database and make it identical to the source database.
DB Schema Difftective has native connections to Oracle, MS SQL Server, MySQL, InterBase, Firebird and PostgreSQL. For each supported database, database specific comparison routines are used. When synchronizing after comparing, database specific synchronization scripts are generated.
| > Download trial > Purchase DB Schema Difftective > Walk-through |
DB Schema Difftective Key Features and Benefits
Compare Database Schemas of Two DatabasesFast comparison of data (inlcuding binary data) in two complete databases or in a selection of tables.Synchronize Database SchemasBased on the comparison results, an appropriate synchronization script will be generated to update the destination schema. Note that database specific SQL (for Oracle, for MS SQL Server, etc) is generated.Support for Multiple Database PlatformsDB Schema Difftective provides direct access to Oracle, MySQL, InterBase, Firebird, MS SQL Server and PostgreSQL. |
Visual Representation of Metadata DifferencesA side-by-side, colour-coded comparison overview makes it easy to pinpoint at a glance similarities and differences between two database objects.Object Dependency HandlingDB Schema Difftective handles object dependencies so database object changes are added to the synchronization script in the correct orderProject-Oriented ArchitectureYou can save your schema comparison and synchronization plan to a project file. This enables you to reuse an existing project as the basis for future database comparisons. |
Editions
DB Schema Difftective is available in 6 editions:- DB Schema Difftective MultiDB Edition (support for Oracle, MS SQL Server, MySQL, InterBase, Firebird and PostgreSQL databases).
- DB Schema Difftective Oracle Edition.
- DB Schema Difftective MS SQL Server Edition.
- DB Schema Difftective MySQL Edition.
- DB Schema Difftective InterBase/Firebird Edition.
- DB Schema Difftective PostgreSQL Edition.
For comparing and synchronizing database data, check out DB Schema Difftective's companion product, DB Data Difftective.
