Compare fixed width files with database table

This page describes how to compare fixed width text files with database tables using DTM Data Comparer.

  • Create custom SCHEMA.INI file in the folder with your text files. Look at an example below.
  • Switch off automatic SCHEMA.INI creation at the Settings->Comparison page
  • Select file to be compared. The program will ignore "format" and "Use header" options if you provide custom SCHEMA.INI file.
  • Run the comparison process

Sample schema.ini file section

Col1=Year Short Width 4
Col2=Month Short Width 3
Col3=Day Short Width 3

The sample file "fixed.txt" has 3 columns (Year, Month and Day), the data type is "Short" for all. Column widths are 4, 3 and 3.