Productivity / Database Tools

DTM Data Comparer
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.

Advertisement


New Downloads of Productivity / Database Tools

Title / Version / Description Size License
Database Browser Portable 5.2.0.1 - This Easy to use tool allows user to connect to any database and browse or modify data ,run sql... 6.2 MB Freeware
ETL-Tools QlikView Connector 3.2.0.2 - ETL-Tools-QlikView connector is the only one which can perform complex data transformations and... 8.3 MB Shareware
Q-Eye QVD/QVX files Editor (64 Bit) 3.4.0.2 - Freeware QlikView QVD/QVX files editor 1000.0 KB Freeware
Data Exchange Wizard 5.1.0.6 - Data Exchange Wizard Loads or export data from/into ANY database. Full support for Excel, Access,... 6.0 MB Shareware
Advanced ETL Processor 3.7.9.8 - Advanced ETL Processor extracts data from any database, transforms, validates it and loads into... 8.3 MB Shareware
dbForge Studio Express for MySQL 6.3 - Free and easy-to-use MySQL GUI tool for essential database management tasks. Includes necessary... 19.0 MB Freeware
Advanced ETL Processor Professional 5.7.10.10 - Advanced ETL Processor Pro extracts data from any database, transforms, validates it and loads... 17.1 MB Shareware
Q-Eye QVD/QVX files Editor (32 Bit) 3.4.0.2 - Freeware QlikView QVD/QVX files editor 1000.0 KB Freeware
Advanced ETL Processor Enterprise 5.7.10.10 - Build Complex Data warehouses and Automate Entire Business Processes, Transfer data from ANY... 21.1 MB Shareware
Universal SQL Editor 1.6.1.1 - Intellisense enabled SQL editor for Oracle, DB2, SQL Server, Sybase, etc., with SQL... 1.7 MB Shareware