Set-up Columns Comparison options

1. Select Comparison Options from Tools main menu.
2. Go to Columns Comparison tab.
3. Use check boxes to select/unselect comparison options, according to your strategy.

   Understanding Columns Comparison options:

   • Case sensitive comparison – if you select this option, column names will be compared according to their case. If you omit this option, columns named "OrderID" and "orderid" (for example) will be considered as columns with the same name. [Default value – omitted].
   • Include identical rows in comparison report – if you select this option, identical columns will be included in the comparison report. If you omit this option, only different or missed on one side columns will be included in the comparison report. [Default value – selected].
   • Include different rows in comparison report – if you select this option, columns considered as different will be included in the comparison report. If you omit this option, only identical columns and columns that exist on one side, will be included in the comparison report. [Default value – selected].
   • Include missing rows in comparison report – if you select this option, columns, existing only on one of the sides, will be included in the comparison report. If you omit this option, only columns that exist on both sides will be included in the comparison report. [Default value – selected].
   • Compare tables/views columns' names – if you select this option, column names will be a part of Columns comparison algorithm. If you omit this option, the column name will not be used in Columns comparison algorithm. [Default value – selected].
   • Compare tables/views columns' data types – if you select this option, the column data type will be a part of the Columns comparison algorithm. If you omit this option, the column data type will not be used in Columns comparison algorithm. [Default value – selected].
   • Compare tables/views columns' length – if you select this option, the column length will be a part of the Columns comparison algorithm. If you omit this option, column length will not be used in Columns comparison algorithm. [Default value – selected].
   • Compare tables/views columns' precision – if you select this option, column precision will be a part of Columns comparison algorithm. If you omit this option, column precision will not be used in Columns comparison algorithm. [Default value – selected].
   • Compare tables/views columns' scale – if you select this option, the column scale will be a part of the Columns comparison algorithm. If you omit this option, the column scale will not be used in Columns comparison algorithm. [Default value – selected].
   • Compare tables/views columns' allow Null – if you select this option, the "Allow Nulls" column property will be a part of the Columns comparison algorithm. If you omit this option, the "Allow Nulls" column property will not be used in the Columns comparison algorithm. [Default value – selected].
   • Compare tables/views columns' default value – if you select this option, the "Default Value" column property will be a part of the Columns comparison algorithm. If you omit this option, the "Default Value" column property will not be used in Columns comparison algorithm. [Default value – selected].
   • Use conversion settings while comparing – if you select this option, the settings defined in "Convert Options" will be used in comparison algorithm. If you omit this option, "Convert Options" settings will not affect comparison algorithm. It is strongly recommended to use this option during comparison. For more info, please see Set-up Conversion rules. [Default value – selected].