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.
DTM Data Comparer: text file to table comparison mode

See also: