The DbCompare utility provides the ability to compare two SQL-based data sources and output a report of the differences, and optionally generate SQL to bring the target into sync with the source.
The dbcompare utility can be run directly from the command line. The dbcompare command is as follows:
dbcompare (tablename...) <optional-arguments>A table name or list of comma separated table names must be included in order for dbcompare to work properly. The dbcompare (tablename…) can be followed by any optional parameters from the command line in the bin directory of the Symmetric instance. The --help option will display all the possible configurable parameters for the compare utility. Possible options include:
--config <arg> : A reference to a properties file path containing additional configuration arguments for dbcompare. This properties file allows you to include table specific configuration and specify arguments such as where_clause and exclude_columns. Where clauses in the file should be formatted as [table].[source|target].where_clause. For example, with a table called item, use item.where_clause=field > now()-2. If you do not specify a table before "where_clause", then it will be used on all tables.
