Data Compare

Compare table data across connections and generate a review-only sync script.

Compare the data in tables across connections. Each side picks a connection, a database, and either a table or - via the Use a query checkbox - an arbitrary SELECT. Key columns come from the primary key automatically, or you name them yourself; both sides then stream in key order through a cancellable merge-join, so the comparison scales past what fits in memory.

Differing rows land in the grid classified as added, removed, or changed - with per-column before and after values - under filter chips for All, Only left, Only right, and Changed, and a summary line counting each class. Script Sync to Editor then generates the matching INSERT / UPDATE / DELETE statements for the direction you chose (left → right or right → left) as a review-only script, so you can reconcile two databases deliberately.

Key problems are reported honestly - missing, NULL, or duplicate key values, or rows arriving out of order (usually a collation mismatch) stop the comparison with a specific message rather than a wrong answer.