Choosing Comparison Options

DBChangeManager provides a wide range of options to customize the way the comparison is to be done. After you specify the resources that are to be compared, you can set the necessary comparison options by switching to the Options tab in the 'New Comparison' Dialog. In this topic we will discuss about the various options provided under the sub-tab Comparison Options

Under Comparison Options you could choose to ignore various settings that would be considered typically for schema comparison. Following is a brief on the various options provided:

Ignore Table Column Order: Choose this option if you do not want DBChangeManager to consider the order in which table columns occur in a table as a comparison difference. By default it would consider table column order and if they are not the same, it will be reported as a difference.
Ignore Case: As the name conveys, choose this option if you want to ignore character case during comparison. By default case will be considered during comparison.
Ignore White Space: Choose this option if you do not want white spaces to be shown as a comparison difference. By default white space will be considered.
Ignore Comments: Choose this option if you do not want to include comments defined within the schema objects for comparison. By default comments will be considered for comparison.
Ignore Constraint Names: Choose this option to ignore constraint names (Primary Key, Foreign Key etc.,) for comparison.
Ignore File Groups: Choose this option to ignore File Groups changes in Tables, Primary Keys, Indexes etc. for comparison
Ignore Full Text Indexes: Choose this option to ignore full text indexes created in the SQL Server database for comparison.
Ignore Permissions: Choose this option to ignore Permission associated with various Users in the database for comparison.
Ignore Owner Names: Choose this option to ignore object Owner names as part of comparison. By default owner names will also be compared.
Ignore Bindings: Choose this to ignore Rules, Defaults Bindings with various objects for comparison
Ignore Identity seeds and Increments: Choose this option to ignore the Identity attribute of Table columns for comparison.
Ignore Index Padding: Choose this option to ignore the Padding option specified on Indexes for comparison
Ignore Collations: Choose this option to ignore Collation differences in character Columns in Tables for comparison
Ignore Statistics: Choose this option to ignore Statistics for comparison

Once you set the required comparison options, next you could filter objects that are to be compared as discussed in the next chapter.