There are a lot of settings which can be tweaked to adjust the behavior of database comparisons.

These are different for each database type and serve many purposes. Common usages include:

• Ignore differences in certain aspects of SQL syntax,
• Ignore differences in line endings
• Ignore differences in whitespace
• Tweak generated SQL - e.g. add object existence checks

For detailed information on all the options see the reference docs.

For more information on how to update these settings see Updating configurations.