關於 Database Comparer Tools

比較、同步和更新資料庫結構。

Database Comparer Tools helps you compare one database with another or databases, with SQL/DDL scripts or even two SQL/DDL scripts. Database Comparer Tools includes an intelligent and robust synchronization algorithm. It takes a Target database or target SQL/DDL script and compares it to the Master database or Master SQL/DDL script. It locates all structure differences and prepares a final SQL script which can be applied to the Target to make its structure equal the Master. Database Comparer Tools extracts all objects, descriptions and links from both Master and Target structures and then compares actual objects from Master with objects from the Target. Database Comparer Tools also supports batch mode so you can synchronize a list of Target databases with a Master database or SQL/DDL script in one pass.

Database Comparer Tools Features

  • Compare database with database, database with SQL/DDL script and SQL/DDL script with SQL/DDL script.
  • Compare and synchronize data between two database tables.
  • Optionally select which objects (domains, tables, procedures, triggers etc.) should be compared.
  • Batch mode for most operations.
  • 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.
  • Build-in additional functionality such as: drop constraints, backup/restore, database validation and many other useful features.