Set-up Structures Comparison options

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

   Understanding Structures Comparison options:

   • Case sensitive comparison – if you select this option, all the table's structure objects will be compared according to their case. If you omit this option, the case of the structure object names does not affect the comparison algorithm. [Default value – omitted].
   • Include identical rows in the comparison report – if you select this option, identical structure objects will be included in the comparison report. If you omit this option, the comparison report will contain only different structure objects and objects missing on one of the databases. [Default value – selected].
   • Include different rows in the comparison report – if you select this option, structure objects, considered as different, will be included in the comparison report. If you omit this option, only identical structure objects and objects missing on one of databases, will be included in the comparison report. [Default value – selected].
   • Include missing rows in the comparison report – if you select this option, structure objects defined only in one of the databases will be included in the comparison result. If you omit this option, the missing structure options from one of databases, will not be included in the comparison report. [Default value – selected].
   • Compare tables/views columns' names – if you select this option, columns' names will be included in the comparison algorithm. If you omit this option, the columns' names will not be a part of the 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, affected by the settings defined in the "Columns Comparison" tab. If you omit this option, the column data type will not be used in the Columns comparison algorithm. [Default value – selected].
   • Compare tables/views columns' length – if you select this option, column's length will be a part of the Columns comparison algorithm. If you omit this option, column's length will not be used in Columns comparison algorithm. [Default value – selected].
   • Compare tables/views columns' precision – if you select this option, column's precision will be a part of the Columns comparison algorithm. If you omit this option, column's precision will not be used in the Columns comparison algorithm. [Default value – selected].
   • Compare tables/views columns' scale – if you select this option, the column's scale will be a part of the Columns comparison algorithm. If you omit this option, the column's scale will not be used in the 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 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 the Columns comparison algorithm. [Default value – selected].
   • Use conversion settings while comparing – if you select this option, settings defined in "Convert Options" will be used in the comparison algorithm. If you omit this option, "Convert Options" settings will not affect the comparison algorithm. It is strongly recommended to use this option during comparison. For more info, please see Convert Options. [Default value – selected].
   • Sort columns by name before comparison - if you select this option, the columns' names will be sorted alphabetically. This sort appears only in temporary DBBalance objects and doesn't affect the real position in the database. Report will be shown alphabetically as well. It's recommended to keep this option selected, in order to simplify visual understanding and manipulations in on-screen comparison report. If you omit this option, columns will be shown according to their actual position in the table. [Default value – selected].