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.
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.