Academic Integrity: tutoring, explanations, and feedback — we don’t complete graded work or submit on a student’s behalf.

I need a tool for Windows that: allows me to compare the data inside two tables

ID: 656917 • Letter: I

Question

I need a tool for Windows that:

allows me to compare the data inside two tables which have the same column name
shows me the disaligned data
allows me to choose a set of rows / cells to copy to the other table

Something very similar to Beyond Compare / Araxis Merge but for comparing tables / views

The concept is pretty easy:

file comparer base their comparison on the file name. Here a join criteria would been provided
file comparer allows to "copy to left" to overwrite the text inside a file; this software should do the same with the "cell" of a database (cell = one column of one row returned by a query)

Does something similar exist already?

Explanation / Answer

Many years ago I used SQL Delta for this purpose. I assume it's still good. A single license is $185 though.

Hire Me For All Your Tutoring Needs
Integrity-first tutoring: clear explanations, guidance, and feedback.
Drop an Email at
drjack9650@gmail.com
Chat Now And Get Quote