| Database Comparer implements
highly intelligent and robust synchronization algorithm.
During first comparison step it takes Target database or
Target SQL/DDL script and compare it to the Master database
or Master SQL/DDL script trying to locate all structure
differences and prepare final SQL script which will be applied
to the
Target and make its structure
equal to Master structure. At this stage Database Comparer
extracts all objects, descriptions and links from both Master
and Target structures and then compares actual objects from
Master with objects from Target building final update SQL
script. After final update SQL script is ready you can apply
it to the Target database if it is available or just save
it to the file and run it later. Database Comparer also
support batch mode so you can synchronize list of Target
databases with given Master database or SQL/DDL script at
one pass. Database Comparer main features: Can compare database
with database, database with SQL/DDL script and SQL/DDL
script with SQL/DDL script.
You can optionally select
which objects (domains, tables, procedures, triggers etc.)
should be compared. Intelligent comparison with automatic
results control after each phase provides excellent results
even if Master and Target structures are very different
and / or have many linked objects. Original and proven algorithms
to synchronize and update linked objects. Batch mode for
most operations.
Build-in additional functionality
such as: - database cloning - data synchronization within
selected tables - drop all constraints or only constraints
with specified type - database backup/restore with batch
mode support - database validation Ability to browse Master
and Target structure trees and visually display the differences
between them. Final update SQL script can be edited or broken
onto separate steps using built-in SQL editor with highlight
feature. You can manually change steps order or optionally
disable selected steps. Detailed context help system included.
Native, highly function and
powerful user interface. If you are database administrator,
developer or just need to support bunch of databases this
tool is designed for you! It will not only save your time
and money but also makes sure that you are not missing anything
and will not get into serious problems which might be caused
by database structure differences. |