DTM Data Comparer-visual tool for data comparison and synchronization with automation facility. HTML or Excel reports, multivendor environment support with unified interfaces: ODBC, OLE DB, etc. Flexible and customizable. Mapping and data conversion.
Sep 8, 2015 21:31:45
Windows ME, Windows NT, Windows 2000, Windows XP, Windows 2003, Windows Vista, Windows CE
DTM Data Editor 1.04.07 DTM Data Editor is a database viewer and editor with BLOB support for professionals who are tired of wasting their time on mundane tasks. The program uses form-based interface and works with any ODBC data source. Automatic SQL statements generation.
DTM Data Generator 2.00.06 DTM Data Generator is a tool that generates data for database testing. It creates test data rows, database tables and schema objects (views, triggers). The tool resolves foreign keys and order of tables automatically. SQL, text, JSON and XML output.
Description: DTM Data Comparer is a visual tool for data comparison and synchronization. The program successively views the contents of both tables basing on the order of ascending of Primary Key (or unique key) values. If the program cannot find two records with the same key value, it places the records to different lines and highlights in yellow. If values of the keys coincide, the program places them to the same lines and highlights equal fields in green and unequal fields in red. When you use mapping, the program leaves columns that don't take part in comparison white.
During synchronization, the program makes the contents of the secondary table equal to the contents of the primary one. In this process records absent in the primary table will be deleted from the secondary one, records that differ will be updated, while records absent in the secondary table will be inserted from the primary one. You can change this behavior using the following options:
1) Delete from secondary - disabling this option will block deleting a record from the secondary table even if there is no such record in the primary table.
2) Insert by primary - disabling this option will block adding records from the primary table even if there are no such records in the secondary table.
"Mapping" feature allows comparing two tables that have different structure (number and name of fields).
During synchronization the program creates a set of insert, update and delete statements for data synchronization. The user can select the necessary statements or forbid the unnecessary ones in a special dialog box.
Database Comparer VCL 188.8.131.520 The Database Comparer VCL (DBC VCL) compares and synchronizes databases structure (metadata) and table data for many popular databases. Currently supported databases: Oracle
dbForge Data Compare for SQL Server 3.9 dbForge Data Compare for SQL Server is a tool to compare and sync data of SQL Server databases. Analyze data differences in a well-designed user interface and synchronize