Setting comparison options

You can use project options to configure the behavior of Schema Compare.

When you create a new project, you should run the comparison with the default options, then review your comparison results. After you have reviewed your comparison results, you may want to consider changing some of the options. The options you set are saved for each project, and you can modify them on the Options tab of the New Schema Comparison wizard.

Options wizard

Default options

If you want to make the current selection of options your defaults, click Save as my defaults. These options will be used for all new projects.

To restore your defaults after making changes, click My Defaults.

Save as defaults

If you need to reset all the options to their original settings, click Devart defaults.

The default options are as follows:

  • Compare database properties
  • Ignore DATA_COMPRESSION for tables, indexes, primary and unique constraints
  • Ignore database and server names for synonyms
  • Ignore database extended properties
  • Ignore user DEFAULT_SCHEMA
  • Ignore logins, certificates, asymmetric keys for users
  • Quote object names with square brackets
  • Force column order
  • Ignore default column collations
  • Ignore history tables names
  • Ignore constraints’ system names
  • Ignore replicated tables
  • Decrypt encrypted objects
  • Ignore keyword reduction
  • Ignore white spaces
  • Ignore WITH option order

For convenience, options are grouped.

Options groups

For each option, a detailed description is provided.

Options description

To search for an option, type search text in the Search box. The list is filtered to display only those options that contain the search text.