There are various comparison options that you can customize via the command line. You can:

  • Choose specific data comparison options instead of the default ones.
  • Select the mapping type between database objects. Instead of default mapping, you can define a custom mapping and manually specify the pair of tables or views.
  • Exclude specific tables, views or columns from the comparison.
  • Override default comparison keys with custom keys.
  • Specify where clauses for tables or views.
  • Define mapping rules for tables or views.

The following sections describe the most common scenarios in details.


Total compare from data to schema with IDERA SQL Comparison Toolset. Learn more > >




  • No labels