Metadata Differences

DBExplorer compares the structure or metadata between two versions of a database. The objects compared include tables, columns, views, procedures, indexes and foreign and primary keys constraints. Once the comparison is complete DBExplorer presents a detailed on-screen summary.

From here DBExplorer can automatically generate the appropriate SQL statements (ie, SQL DDL - Data Definition Language) to bring the database up to date. Depending on the differences detected this may be a "CREATE TABLE/VIEW/PROCEDURE" or a "ALTER TABLE ADD COLUMN." type statement. These generated SQL statement can be saved to a separate SQL script file for later execution or applied directly.

The entire comparison results can also be saved to a document file or printed out as a HTML report.