Table of Content
- General
- Product profile
- Connect
- Comparison
- Warnings
- Synchronization
- Table to Table Mode
- Query to Table Mode
- Query to Query Mode
- File to Table Mode
- File to Table, Fixed width
- Excel to Table Mode
- Database Mode
- Synchronous Navigation
- Face-to-Face View
- Key Definition
- Column Mapping
- Settings
- Project Properties
- Script Viewer
- Command Line
- Console Mode
- Process Cancellation
- Comparison Report
- Report Customization
- Collate Window
- Table List Menu
- Run SQL statement
- SQL Console
- Hot Keys
- Information
File to Table comparison mode
This mode allows users to compare text file (tab-delimited, CSV file or custom delimited) with the database table or view content.
Currently, the program supports following file formats: tab-delimited, CSV, custom-delimited and fixed width files.
The file can contain or not contain a row with column names.
In the second case, the program will name columns as F1, F2, ... Fn.
DTM Data Comparer saves the file name associated with the right side table to project file. When the user selects the table with stored file name the program restores it.
In the synchronization process, the right side table will be modified to the file content state.
Important notes:
- Unique key for the file must be entered manually by the user in any case.
- The program requires "Write" and "Create file" access rights for the folder with the text file to manage SCHEMA.INI file. You may ignore this requirement in case create own SCHEMA.INI file manually together with the related option.
See also:
- How to compare fixed width file using DTM Data Comparer?
- Table to Table comparison mode
- Query to Table comparison mode
- Query to Query comparison mode
- Excel to Table comparison mode.
- Database comparison mode.