DTM Schema Comparer is a tool for comparing database schemas. The comparison process supports tables, views, indexes, triggers and stored procedures. The visual representation of database schemas as a tree makes the comparison process more comfortable. The built-in SQL text comparison tool allows you to view two scripts with differences displayed in a comfortable way.
The synchronous navigation through the schemas tree allows you to easily compare items in as detailed way as you need.

Information in the main program window is divided into four levels. The first three levels are presented separately for each of the databases being compared as left and right panes. The first level is a set of buttons for connecting to databases, refreshing the connections and disconnecting from the data source.
The second level contains database schemas in the form of a tree with icons for displaying the comparison results or '?' signs if the comparison process is not completed yet. The legend of icons is described below. The third level shows the texts of the database objects currently selected with the syntax highlighting feature. The SQL window shows text for the currently selected database object (table, view, procedure, etc.).
The comparison buttons are located at the bottom of the window (level 4). Also, you can open the "SQL text comparison tool" window using the 'Compare texts' button. Note: all these buttons are disabled during the comparison process.

There are four icons for nodes in the schema tree. The question sign means the comparison process is not completed yet. If you are already connected to both databases, click the "Compare" button to start the process. Please be patient, the comparison process for complex schemas may take several minutes or (for thousands of database objects) even dozen minutes. The red icon means objects (or their child objects) are not equal. The yellow icon means objects have the same name, but different internal structure. The green icon means objects are equal.

How does the program compare database schemas?

Tables are compared item by item, the program compares the lists of columns. If the names of two columns are equal, it compares their types, sizes, decimal digits (if applicable), nullability, default values, primary and foreign keys.
In other cases the program compares the SQL scripts of objects.
Note: indexes and triggers from a table are placed in a separate sub-tree and the program compares them independently of their table.