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 > >