DTM Schema Comparer

Aiming to ease the work of database administrators, DTM Schema Comparer provides a scalable schema comparison and synchronization tool with support for all major database servers. Such an application can be used not just to check whether there are differences between the structures of two different databases or instances of the same database, but also update schemas.

You are welcomed by a wizard designed to guide you through all the steps you need to take to successfully connect to the two databases and configure the comparison process. DTM Schema Comparer is compatible with some of the most popular database systems, including SQL Server, Oracle, MySQL, FireBird / Interbase, IBM DB2, or PostgreSQL. It offers support for ODBC, IDAPI and OLEDB interface connections and can load local databases files or file DSNs.

Further on in the steps of the wizard, you must customize the comparison options. DTM Schema Comparer can deal with tables, indexes, views and triggers, default values, primary and foreign keys, constraints, or comments.

The two database schemas are visually represented in tree-view, side-by-side, which makes the comparison process more comfortable. Due to the synchronous schema navigation, you can go through all the categories one by one, and compare the data thoroughly. Moreover, DTM Schema Comparer features a built-in SQL text comparison tool that helps you explore differences between two scripts or other database objects.

While comparing data, the application can also create a synchronization SQL/DDL script and optionally execute it. Partial synchronization is also possible, as you can authorize DTM Schema Comparer to only create, drop, or alter objects.

All this information can be included in a comprehensive database comparison report that highlights differences and generates a statistical summary of orphaned, matching and non-matching items.

This application enables you to compare schema items in detail and perform database schema synchronization in a simple manner. Thanks to the integrated wizard and a few other aces up its sleeve, DTM Schema Comparer is a reputable schema viewing, comparison, and synchronization application.