Validate the copy

Proof that the destination holds what the source has.

Last updated November 19, 2026

A run can finish without errors and still leave changed data. Some servers store a value they cannot hold in another form instead of refusing it. Validation finds this.

Watch on YouTube (1:24)

Three levels

  • Schema - every table and column is in the destination, with the planned type.
  • Totals (Validate data) - row counts, sums, earliest and latest dates and the total text length match on both sides. Fast: no rows are read.
  • Rows (Compare rows) - every row in the destination matches the row that was copied. Shows which rows and which columns differ.

"Totals match" is not "every value matches". A character written as ? keeps the length and every sum. Only Compare rows finds it.

Validate after the run

Tick Validate after the run under Validation on the Execution step. The copy then remembers every row it writes and checks the destination as soon as it ends. The copy is a little slower.

Compare rows is only available for runs made with this option on. Without it you can still check schema and totals.

Execution step: Validate after the run ticked under Worker threads

When a table differs

The table shows what differs, for example born — min: source 1712-06-01, destination 1753-01-01. A SQL Server DATETIME column cannot hold dates before 1753.

Completed, validation found differences: customers born, min source 1712-06-01, destination 1753-01-01; row 1 changed, in the target name Zoe Martin, born 1753-01-01

  1. Click Compare rows for that table to see the rows.
  2. Change the column's type in Tables & mapping, or fix the values in the source.
  3. Run the job again.