Core Options

DA server provides various comparison and job options, which you can use to optimize row and schema comparison queries.

• Compressed Data Transfer (CDT)
  During CDT, the row data between remote DA agent (excluding local DA agent) and DA server gets compressed thereby improving overall comparison time in distributed environments that have high network latency.
• External Sort Option
  An order by clause specifies that a select statement returns a result set with the rows being sorted by the values of the key columns.
• Database Hash Comparison
  The database_hash comparison option is supported only for Adaptive Server-to-Adaptive Server comparisons.
• Large Objects Support
  All LOB types use a “first N bytes” parameter, where N is a configurable with lob_fetch_size parameter. If the number of bytes in the LOB column is less than “N”, the entire column value is used.
• Adaptive Server Hashbytes Null Handling
  The Adaptive Server Transact-SQL® hashbytes function ignores null values.
• Data Reconciliation Option
  DA server can fix data differences between your source and target databases.
• Scheduling Options
  When you create a comparison job, you can assign specific schedules to it.